Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Show Question based on 2 yes items from multiple questions

Show Question based on 2 yes items from multiple questions 2 years 8 months ago #107076

  • andogro144
  • andogro144's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
I have a survey where a question is asked based on endorsements of 2 previous questions. There are 8 items previously which are y/n questions. If a user says yes to 2 or more of these than we ask the next question. I am struggling with what logic to use here, as there are many possible combinations, and it can't just be yes to 1 item, but must be 2 or more.

Would it make sense to create an equation question that sums these up and ask based on that? If so a pointer to an example would be great!

Here is a simplified example (there are also questions in between these, so would be pulling them out from a longer list).

Did alcohol make you feel:
anxious y/n
sick y/n
depressed y/n
restless y/n
hallucinate y/n
seizures y/n
headaches y/n
sweating y/n

If yes to 2 or more above, then ask:

did this cause problems for you.

Thanks for any insight!
The administrator has disabled public write access.

Show Question based on 2 yes items from multiple questions 2 years 8 months ago #107089

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9555
  • Thank you received: 1373
  • Karma: 389
Hi,
if Question code are ALC and each alcahol are SQ01,SQ02 ...
sum(ALC_SQ01=="Y",ALC_SQ02=="Y" .... ,ALC_SQ10=="Y")>=2
or maybe you can try:
sumifop("==","Y",ALC.that)>=2
but this one is not tested
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time (Need support ?).
A bug not reported is a bug not corrected. | 2.61lts version improved | Need plugins for LimeSurvey ?
Last Edit: 2 years 8 months ago by DenisChenu.
The administrator has disabled public write access.

Show Question based on 2 yes items from multiple questions 2 years 7 months ago #107325

  • andogro144
  • andogro144's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Thanks Denis, I appreciate your help! Worked when I deleted other conditions and put into the relevance equation field.
The administrator has disabled public write access.

Show Question based on 2 yes items from multiple questions 2 years 7 months ago #107340

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9555
  • Thank you received: 1373
  • Karma: 389
Yes, need to delete condition.

Did you test the sumifop ?

Denis
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time (Need support ?).
A bug not reported is a bug not corrected. | 2.61lts version improved | Need plugins for LimeSurvey ?
The administrator has disabled public write access.
Time to create page: 0.208 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form