choice_filter with using multiple question dependencies

GeoWorld13

I am trying to configure a survey that applies choice filtering for 3 questions. Here are the scenarios:

1. {tribal_gov} = Yes: show all 32 choices

2. {tribal_gov} = No, {state_esf} = No: show all 32 choices

3a. {tribal_gov} = No, {state_esf} = Yes, {esf_num} = 1 : show 1 choice

3b. {tribal_gov} = No, {state_esf} = Yes, {esf_num} = 2 : show 3 choice

3c. {tribal_gov} = No, {state_esf} = Yes, {esf_num} = 3 : show 2 choices

Some core capabilities can apply to multiple esf numbers 

Scenarios 1 and 2 work. Scenarios 3a, b, and c do not. The drop-down option is not available in scenarios 3a, b, c

choice_filter statement: ${tribal_gov}='Yes' or ${state_esf}='No' or selected(esf_filter, ${esf_num})

Choices tab:

I am adding a space between each ESF. Perhaps that is not correct? esf_1 esf_2

 

Georgios-NektariosTselos

Hi @GeoWorld13 , 

It looks like the issue is in the logic used for scenarios 3a/3b/3c.

When {state_esf} = Yes, your choice_filter probably needs to evaluate BOTH conditions together:

• ${esf_num}

• and the values used in the choices sheet

If some capabilities belong to multiple ESF numbers, avoid using direct equality (=) against a concatenated field. Instead, use selected().

For example, if your choices sheet contains a column like:

esf_filter
1 2 3
2 5
1

then your choice filter should be something like:

(${tribal_gov}='Yes') or
(${state_esf}='No') or
(${state_esf}='Yes' and selected(esf_filter, ${esf_num}))

The important part is:

selected(esf_filter, ${esf_num})

instead of:

esf_filter = ${esf_num}

because several core capabilities can belong to multiple ESF numbers.

Also make sure:

• esf_filter values are space-separated (not comma-separated)

• ${esf_num} matches the choice name values exactly

• the choice_filter column is on the question using the filtered list