Check out the LimeSurvey source code on GitHub!

Show Question based on 2 yes items from multiple questions

More
2 years 10 months ago #107076 by andogro144
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!

Please Log in to join the conversation.

More
2 years 10 months ago - 2 years 10 months ago #107089 by DenisChenu
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.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
Last Edit: 2 years 10 months ago by DenisChenu.

Please Log in to join the conversation.

More
2 years 10 months ago #107325 by andogro144
Thanks Denis, I appreciate your help! Worked when I deleted other conditions and put into the relevance equation field.

Please Log in to join the conversation.

More
2 years 10 months ago #107340 by DenisChenu
Yes, need to delete condition.

Did you test the sumifop ?

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form