Using multiple filters: Other filters clear when changing option in one?

[mockingjay48]

Hi! Hopefully I can explain this in a way that makes sense. We have a container that includes multiple drop-down lists that allows the user to filter data (e.g., they can filter by race/ethnicity, gender, and age) for various charts. What we have noticed, however, is when you update the selection within one drop-down list, the drop-down lists that follow are cleared and you have to re-select those filtering options as well (but any drop-downs before keep their original selection). For example, if I wanted to view data for African American males who are between the ages of 18-22 and then I change my selection from male to female, the African American filter selection will remain but the age filter is cleared and I'll have to re-select the 18-22 option.

With that long-winded description, my question is: When using multiple filters, do I have the option to make all other filter selections remain unchanged when I change my selection within one filter?

[Sam_SAS]

Hello,

I believe that this happens when there are filtering interactions between the controls, e.g., Drop-down list A filters the values of Drop-down list B. In some cases this is desirable, but not always!

You might want to check the Actions pane for each control and turn off Automatic actions and any actions between two controls.

Let us know if that helps,

Sam

[Madelyn_SAS]

If the filters are not linked, you could run into a situation where FilterB contains a value that is not compatible with FilterA, which means that objects will be blank and show warnings because all data will be filtered out. 

[acordes]

I've re-created the behavior you face when updating the filters. 

In my experience the de-deselection at filter 3 (here the list object) only happens if a filter that comes before gets updated (here the drop-down list, filter 2) AND not all the values populating the filter 3 are available for the new selection at filter 2.