Filtering questions based on previous response (in a multiple choice)

Hello @Kal_Lam
I need your help. I have a multi choice select question with a list of brands as answers. I want my next question to filter the various sub brands based on the selected brands from previous question.

Q1. Which brands of water do you sell at your shop?
Opt 1: Smart water
Opt 2: Voltic water
Opt 3: Menia water
Opt 4: Lilly Water
Opt 5: Blessed water
NB: This should be a multi-select question

Q2. Which various sub-items are available at the moment?
if Opt 1 was selected, show:
a. Smart water 500ml
b. Smart water 700ml
c. Smart water 1.5l

if Opt 2 was selected, show:
a. Voltic water 500ml
b. Voltic water 700ml
c. Voltic water 1.5l

if Opt 3 was selected, show:
a. Menia water 500ml
b. Menia water 700ml
c. Menia water 1.5l

if Opt 4 was selected, show:
a. Lilly water 500ml
b. Lilly water 700ml
c. Lilly water 1.5l

if Opt 5 was selected, show:
a. Blessed water 500ml
b. Blessed water 700ml
c. Blessed water 1.5l

NB: My answers for Q2 should be based on the Main Brands selected in Q1.

Thank you.

Welcome to the community, @Odade3! And is Q2 a multi-select question too?

Yes it is a multi select question too. :relaxed:

@Kal_Lam . Yes, that is true. Q2 is a multi select question too.

OK, if this is the case, you could do it as outlined in the image shared below:

In the survey tab of your xlsform:

In the choices tab of your xlsform:

In the settings tab of your xlsform:

Image 3

Data entry screen as seen in Enketo:

Reference xlsform:

Cascading Select.xlsx (15.1 KB)

Note: You will have to be extra cautious while analyzing your data as this approach uses the allow_choice_duplicates.

It worked but now my issue am facing is,
On Q3. Am picking all the selected items on Q2 to begin a repeat on choices but it is giving me all options, even those I didn’t select.

See attached video.

I have sent you 'the file am working with. So you can have a look
iceUploadFileforKobov3.0.xlsx (36.9 KB)

@Odade3, is this related with the same issue or is it a different issue? If different, it would be good to create a new topic?

Besides, could you add a dummy question/condition to my sample file (to demonstrate on what is not working)?

I have achieved what I asked but is creating another issue in my next question.

In such case, please try creating a different topic. That would make our issues systematic. Thank you for your understanding!