The LimeSurvey Fund-Raiser 2012 is complete. Thank you for donating a total of 25,000 USD!     List of donors »
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username?
  • Page:
  • 1

TOPIC: Hiding a question when all answer rows are filtered out of view

Hiding a question when all answer rows are filtered out of view 4 months 2 weeks ago #90772

  • JoyLaneResearch
  • JoyLaneResearch's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 16
  • Thank you received: 1
  • Karma: 0
Imagine two questions on separate pages (groups) in a survey:
Q05B - Which colors of widgets do you carry? [MULTIPLE RESPONSE QUESTION TYPE]
1 Red
2 Green
3 Blue
Q06B - How many of each do you have in stock? [MULTIPLE NUMERIC QUESTION TYPE]
1 Red _____
2 Green _____
3 Blue _____

I have an Array filter on Q06B set pointing to Q05B so that only rows answered in Q05B appear when Q06B is displayed. This filter is set correctly and works as expected.

At present, when I test the survey without choosing any of the responses in Q05B, the questions text for Q06B appears with no answer options. What would be the appropriate technique for setting a relevance equation for my Q06B so that it does not appear when none of the options are answered in Q05B?

I've tried summing, i.e., sum(Q05B_1.NAOK, Q05B_2.NAOK, Q05B_3.NAOK) > 0. I've also tried experimenting with !is.empty(Q05B_1.NAOK), etc., but I couldn't get it right. Any guidance would be appreciated!

Thank you!
The administrator has disabled public write access.

Re: Hiding a question when all answer rows are filtered out of view 4 months 2 weeks ago #90788

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 4430
  • Thank you received: 460
  • Karma: 167
Hello,

try:
sum(Q05B_1.NAOK=="Y", Q05B_2.NAOK=="Y", Q05B_3.NAOK=="Y") > 0

If not:
(Q05B_1.NAOK=="Y" or Q05B_2.NAOK=="Y" or Q05B_3.NAOK=="Y")

Denis
The administrator has disabled public write access.

Re: Hiding a question when all answer rows are filtered out of view 4 months 2 weeks ago #90813

  • tpartner
  • tpartner's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2870
  • Thank you received: 428
  • Karma: 246
You can still use the conditions designer to generate your relevance equations.
Cheers,
Tony

LimeSurvey is open-source and run entirely by volunteers so please consider donating to support the project.
The administrator has disabled public write access.

Re: Hiding a question when all answer rows are filtered out of view 4 months 2 weeks ago #90847

  • JoyLaneResearch
  • JoyLaneResearch's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 16
  • Thank you received: 1
  • Karma: 0
Denis

Your second suggestion worked perfectly!

A note to anyone seeking to implement it in their own survey: be careful of case. The first time I tried the solution, my relevance equation was in all caps, but my question lables had were in mixed case. Once I fixed that, the solution worked.

Thanks!
The administrator has disabled public write access.
  • Page:
  • 1
Moderators: DenisChenu, ITEd
Time to create page: 0.293 seconds
Donation Image