Skip to main content

Good morning,

 

I'm working with Celonis EMS Studio (with packages, no with views), and I have two dropdowns like a filter. 

I would like when select one value of the first one, the another dropdown put only the posibles values to select in this columns (not appear in gray, behaviour similar to 'FILTER FORCED').

 

For example, I have countries and cities like dropdowns, when select Spain, would like have only the cities of Spain (and not cities of another country in gray like now).

 

Thank you very much.

 

Kind regards.

Hi Pedro,

You can achieve this with two Button dropdowns in the analysis. The first one should be the country selection, which can write the selected value into a variable. Then in the second button dropdown, depending on the data structure you have you can either write a case when statement to handle the different countries, or/and do the filtering with a PU function to get the list of the cities for the selected country.

This way only the relevant options will be visible in the second selection.


Reply