Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

I want to create a summary table

  • yuto0419
  • yuto0419's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
1 year 8 months ago #243434 by yuto0419
I want to create a summary table was created by yuto0419
I want to create a summary table with Question type - Array (Texts) based on the values entered in Question type - Array (Texts).

From question 1 [Question type - Array (Texts)] below,
 ・Type
 ・sex
 ・age
 ・Length of service
Based on
I want to display the number of people corresponding to question 2 [Question type - Array (Texts)] below.
 


In particular
 ・Corresponds to Type: A, Sex: Man
 ・Rows: by age
 ・Column: By years of service
I want to aggregate in the form of.
 


I want you to lend me your strength.

 

File Attachment:

File Name: limesurvey..._321.lsg
File Size:109 KB

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 8 months ago #243457 by Joffm
Replied by Joffm on topic I want to create a summary table
Hi,
1. Why didn't you answer the questions at the beginning? It is not a joke that we ask them.
2. Neither provide lsq nor lsq exports, only lss. Copy the survey, remove everything not related to your question, send this as lss export.
Reason: lsq and lsg exports are language sensitive. You can't import them into a survey with a different base language.

So, what do you want to do.
You only want to display the entries of the first table in some aggregated way in the next tables (I assume there will be more, like "Man, Type B", "Woman, Type A",...)

Well this you can do by some equations 
E.g. the first cell "under 20, less than 1 year" for "Man, Type A"
Assuming, the y-axis is coded "Y001", "Y002",... and the x-axis "X001", "X002", ...

Q2_Y001_X001={sum(if(Q1_Y001_X002==1 and Q1_Y001_X003==1 and Q1_Y001_X005<20 and Q1_Y001_X002==1 and Q1_Y001_X009<1,1,0), if(Q1_Y002_X002==1 and Q1_Y002_X003==1 and Q1_Y002_X005<20 and Q1_Y002_X002==1 and Q1_Y002_X009<1,1,0),
if ...   for all rows
)}

Q2_Y001_X002=
Q2_Y001_X003=
...
for all cells of your second question.

Joffm
 

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: yuto0419

Please Log in to join the conversation.

Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose