Welcome to the LimeSurvey Community Forum

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

Filter a 0-10 scale table subquestions based on a prior multiple choice question

  • bmarketing.esurvey3
  • bmarketing.esurvey3's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 11 months ago - 2 years 11 months ago #221944 by bmarketing.esurvey3
Hi, 
I was wondering how to filter subquestions to show based on a prior multiple choice question.
I attached the lss file :  

File Attachment:

File Name: limesurvey... (3).lss
File Size:419 KB

what i want to do is : 
  1. If answer to subquestion 1 of the multiple choice question "eqNotoToCombi"  is choosen, show subquestion 1 of question "Q5Bis"  
  2. If answer to subquestion 2 of the Y/N table question "Q4"  is choosen, show subquestion 2 of question "Q5Bis"  ... and so on for subquestions 3 to 16.
I started trying this way but it didn't work at all : 

 
 
Can you please help me with this ? thanks in advance.
 
Last edit: 2 years 11 months ago by bmarketing.esurvey3.
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 11 months ago #221949 by Joffm
Hi,
1.

multiple choice question "eqNotoToCombi"  is choosen

"eqNotoToCombi" is not a multiple question, it is an question of type "equation" that sets the multiple question "QNotoCombi"

2. The last line in this equation is wrong.
{QNotoToCombi_99=if(Q1_1=2 AND Q1_2=2 AND Q1_3=2 AND Q1_4=2 AND Q1_5=2 AND Q1_6=2 AND Q1_7=2 AND Q1_8=2 AND Q1_9=2 AND Q1_10=2 AND Q1_11=2 AND Q1_12=2 AND Q1_13=2 AND Q1_14=2 AND Q1_15=2 AND Q1_16=2 AND Q0Combi_99=="Y","Y","")}
Read the manual about single "=" and double "==" equal signs.
[url] www.limesurvey.org/manual/ExpressionScri...t_Operator_.28.3D.29 [/url]

3. In this line you'd better use the function "countif".
Like
{QNotoCombi_99=if(countif("1",that.Q1)==0 AND Q0Combi_99=="Y","Y","")}
Read the manual about "implemeted functions"
[url] www.limesurvey.org/manual/ExpressionScri...mplemented_functions [/url]

4. There are no relevance equations in Q5Bis.

And please, ALWAYS mention the LimeSurvey version you are using.

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • bmarketing.esurvey3
  • bmarketing.esurvey3's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 11 months ago #221955 by bmarketing.esurvey3
Thank you so much Joffm, that was very helpful.
The topic has been locked.
Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose