Welcome, Guest
Username: Password: Remember me

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

Show Question based on 2 yes items from multiple questions 4 months 3 weeks 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 4 months 3 weeks ago #107089

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6268
  • Thank you received: 800
  • Karma: 239
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
Last Edit: 4 months 3 weeks ago by DenisChenu.
The administrator has disabled public write access.

Show Question based on 2 yes items from multiple questions 4 months 2 weeks 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 4 months 2 weeks ago #107340

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6268
  • Thank you received: 800
  • Karma: 239
Yes, need to delete condition.

Did you test the sumifop ?

Denis
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.202 seconds
Donation Image