# Show Question based on 2 yes items from multiple questions

3 years 7 months ago #107076
andogro144 created the topic: Show Question based on 2 yes items from multiple questions
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
sweating y/n

If yes to 2 or more above, then ask:

did this cause problems for you.

Thanks for any insight!

3 years 7 months ago - 3 years 7 months ago #107089
DenisChenu replied the topic: Show Question based on 2 yes items from multiple questions
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).
An error happen ? Before make a new topic : remind the Debug mode .
Last Edit: 3 years 7 months ago by DenisChenu.

3 years 7 months ago #107325
andogro144 replied the topic: Show Question based on 2 yes items from multiple questions
Thanks Denis, I appreciate your help! Worked when I deleted other conditions and put into the relevance equation field.

3 years 7 months ago #107340
DenisChenu replied the topic: Show Question based on 2 yes items from multiple questions
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).
An error happen ? Before make a new topic : remind the Debug mode .