I want to be able to filter a table with a multi select control where the selected values are excluded from my table. I have created the following simplified example to demonstrate my issue.
I have a multiple string value parameter called pExclusions.
I have a multi select dropdown control with a few values specified for the list.
I have a filter on Salesperson, where I am defining that the filter does not equal the values from my parameter list.
When I don’t select an values in my control, I get all the Salesperson names as expected.
When I check Anne Smith and Gerri Hinds, they exclude from the table as expected.
However, if I want to exclude all the names in my control dropdown list, it doesn’t work. If I choose Select All to check all the names (which is what I want the default to be for this dashboard), then I get the wrong behavior and all data is returned.
Hi, thanks for the feedback, this is a known issue and we are going to work to fix it.
The reason for the issue is that “select all” is bahaving same as clear filter, therefore in this case, instead of filtering out all the value from the list, it is turning the filter off, which gives you the whole list.
Hi @emilyzhu when can we expect the issue to be resolved? We are almost in Q4-23!? Is there any work round to avoid this behavior? We have many users complaining about the issue.
Hi @Kristin, so it can be this year, next year … this is soo vague … what shall we advise our customers then? It’s getting harder and harder to convince them that QS is the right tool!
I’m facing essentially the same issue, here’s my scenario:
I have a Custom Filter List, consisting of the values ‘Yes’ and ‘No’ and excluding Nulls.
I have a control configured for this filter, which is a Dropdown/List multiselect with specific values (‘Yes’ and ‘No’)
Every time the control is displayed as a dropdown the issue occurs:
At first, the visual displays the correct data (filtered by ‘Yes’ or ‘No’ values)
And the control indicates that is showing All the results
When I use the ‘Select all’ option or I select manually all the values on the control
Then the Filter breaks up showing not expected records
When I use the ‘3 dots > reset’ option
The I can get the expected behavior again
I mention that the issue is related to the “dropdown display” of the control, because I can reproduce the issue in these scenarios:
The control is a Dropdown multiselect and is displayed on top of the sheet
The control is a Dropdown multiselect and is displayed on inside the sheet
The control is a List multiselect and is displayed on top of the sheet (thus rendered as a select)
BUT I get the expected behavior in this scenario:
The control is a List multiselect and is displayed inside the sheet
@emilyzhu This has been marked as solved in May 2022 as a known issue, but how is it that in two years it has not been resolved yet? Is it possible to have a reference to a ticketing system where we can follow the prioritization and the resolution of this bug?
