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?
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
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.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.