I have a ranking question that has 6 options. Two of which are: Not sure and No preference.
If either of these are included the ranking, then no other options should be allowed to be ranked.
I've attached my question file. I found another post that talked about exclusive options in a ranking question, so I copied the suggested validation logic. But when you look at the question, pretty obvious it doesn't work -- just not so obvious to be me how to make it work.
Please attach survey exports (.lss files) containing only the relevant question(s). Question/group exports force us to do more work trying to help you.
Cheers,
Tony Partner Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Given that the question code is Q51, the exclusive answer codes are 5 and 6 and there are maximum 3 answers, this should be the question validation equation.
Code:
(Q51_1 == '5' AND is_empty(Q51_2) AND is_empty(Q51_3))
OR
(Q51_1 == '6' AND is_empty(Q51_2) AND is_empty(Q51_3))
OR
(Q51_1 != '5' AND Q51_2 != '5' AND Q51_3 != '5' AND Q51_1 != '6' AND Q51_2 != '6' AND Q51_3 != '6')
Having said that, it may be an idea to insert a previous question asking whether they want to rank and use relevance to hide/show the ranking question. (I find it odd to rank an option "Unsure" or "No preference")
Cheers,
Tony Partner Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.