What is the problem? Please be detailed. I have a list of choices. first question asks about the main item and is a select_one scenario. the second question is to select other minor items from the same list and is a select_multiple scenario. I would like to have it designed such that after selecti…

Great tip, @jules_rugwiro . I don't believe the filter column is necessary. A simpler choice_filter condition given that var1 is the first name of the first select would be name != ${var1}. This may make it a little more clear that all we're doing is including all the values that didn't get selected …

Hello Green, It's possible to achieve this. you will need to use filters as indicated below: Involved columns are "choice-filter" in survey and "filter" in choices. Step one: Define the choices (name and label) in the choices and then add an extra column called "filter" of which the content is t…

Thanks a lot guys. Problem solved. I only had to use the choice_filter.

Glad you got it working, @Immie_Green ! @jules_rugwiro asked me a really good question in private message and I hope he won't mind that I answer here because I'm sure others have it too. The question is what exactly name represents in the name != ${var1} expression. It is indeed strange because it'…

Hello @LN Thanks a lot for the clarifications. Your approach saved me more that hours today. I was creating a form that had quite a number of filters I wouldn't have managed relying only on my old school method. On a different note, do you have any automated way/tool that you use to generate SPSS …

I'm so glad the explanation was helpful, @jules_rugwiro ! And that was thanks to your initial helpful response -- sometimes answering questions is the best way to learn. [image] jules_rugwiro: do you have any automated way/tool that you use to generate SPSS Data dictionary straight from the XLSF…

Hi. I tried this but it only works if you select one option. It doesn't work for multiple select questions for me. Any clue why?

When you have a multiple select, the answer can contain multiple options so you don't want to compare it using =. Instead, use the selected function . The filter would look something like not(selected(${var1}, name)). This is what @jules_rugwiro had originally suggested. I tend to use =/!= when usin…

ODK Forum

Returning a list of multiple select questions which doesn't contain a previously selected choice

Support