HelloI have a question is it possible to design the following table in the LimeSurvey. The red parts are explain the functions of each column.
 

I already know how to implement each column in one table, just like: 





But I do not know how to show all of them in one table. I really appreciate your help. Thank you.


 

I wonder, why you didn't fill the required informations about LimeSurvey version, hosting, theme.

As the first three columns are calculated, but fixed numbers you may insert a HTML table into each subquestion text
 


Or you use an array, fill the first three columns by an equation, set them to "readonly"
 

But as long as your explanations are too vague, like "where the values are answered in previous questions" or "X is a dynamic number" I can't show.
In this example I used questions of type "multiple numeric input" resp. "numeric input" to enter some values that were calculated and displayed in this table.

So, provide a lss export of this part of your survey, that includes all necessary questions.

Joffm

thank you Joffm. this is the LSS fils. 
 

Hi,
sorry, I do not understand this.

What is asked in A1? Obviously not the price of apples, if I only can insert a number from 1 - 10 in each category.

And you should use Expression Manager instead of this INSERTANS stuff, like
under {sum(AP1_Q1_A1*1,AP1_Q1_A2*1.05,AP1_Q1_A3*1.1,AP1_Q1_A4*1.15,AP1_Q1_A5*1.2,AP2_Q1_A1*0.9,AP2_Q1_A2*0.95,AP2_Q1_A3*1,AP2_Q1_A4*1.05,AP2_Q1_A5*1.1)/100*5} €
This you could easily shorten more.
Instead of two questions "AP1" and "AP2" you may use only one "AP" with "micro-tayloring" of the texts, and a random number (0 - 0.1), instead (1 - 2), calculated {if is_empty(randnumber),(rand(1,2)-1)/10,randnumber}
 

Knowing that the values of AP2 always are 10% lower than AP1 the above function is only
under {sum(AP_Q1_A1*(1-randnumber), AP_Q1_A2*(1.05-randnumber), AP_Q1_A3*(1.1-randnumber), AP_Q1_A4*(1.15-randnumber), AP_Q1_A5*(1.2-randnumber))/100*5} €

Just an idea.

And "5" resp. 7.5 ,... are the fixed prices? I thought they were entered somewhere?

 

And where is the array you are looking for?
You see, without any question text, without any explanation, how can I help?

Here I send you an example how to create your array, two different ways.

 

Anyway, you see how you calculate numbers, how you preset the array.

Joffm

And here a much shorter sample survey of your provided example.
 

Joffm

Thank you Joffm.

I am sorry for not clearly explaining my questionnaire.

for the question "Gp1random", actually, I need to choose 2 numbers from 4 (It had been solved with your help ). In this example, I just brief it, so I only create "AP1" and "AP2".

The following table is what I want.
  Now  I find some wrong in my limsurvey. Do you know the reason?

 

Thank you

 


 

Yes,
1. you see that I coded the subquestions of y-axis with "Y001", "Y002", ... and the x-axis with "X001", "X002", ...
In my opinion it is better to remember than Q1_SQ002_SQ003 (what was colmun, what was row?)

But in your "Q2" you still use "SQ00x" for both axis.

2. A1 is defined an array question.
But here A1 has only one dimension like a multiple numeric question {Q2_Y001_X002=A1_Y001}

3. Neither "DN" nor "Q01" exist in this survey.

Seems you only imported group "G2" from the "apples" example into your without taking into account the other questions that it depends on.

Joffm


 

Thank you, it works now. 

I still have two questions 
 1, how to hide the first column. 


2. Is it possible to make the filled number (last column) less than the "Numbers existed" column? If the  "Numbers existed"  is 3, the filed number should be less or equal to 3.

1.[url] www.limesurvey.org/manual/Question_type_...subquestion_width.29 [/url]
0 is valid, too.

2. question validation
[url] www.limesurvey.org/manual/Question_type_...28em_validation_q.29 [/url]

Joffm

Thanks for your time and patience.

you give me a good way to shorter my questionnaire, using {if(randnum==0,"the same","10% higher")}

if I choose 1 from 4, how to use this code
Randnum ==0 "the same"
Randnum ==1 "10% higher "
Randnum ==2 "20% higher "
Randnum = "30% higher "