Cascading filters - treat nothing selected as selected all

[ksenstad]

Hello!

We have multiple cascading filters when filters affect each other values. For example we have series filter that affects subseries filter. For example I’ve selected series-3 and subseries filter showed only the subseries of series-3.

Now, what we want to achieve is that when nothing is selected at all in the series, it’s treated in a same way as if select all was selected on this filter. Right now if nothing is selected, it’s not showing anything for subseries, which is expected behavior. Although we are looking to find a workaround to achieve what we would like to achieve.

I’ve tried added OR condition which look like this

and this basically means all and I can see that data appears in the table

But the cascading filter subseries doesn’t show anything. Seems like it just focuses on the first part of the condition, because if I select again some series, the subseries will show me only the ones belonging to series.

Is it even possible to achieve what we would like to achieve?

Best regards,
Kseniya

[duncan]

Hello @ksenstad

Can you provide a breakdown of how your parent and child filter were created, for example how are you creating the blank by default?

@ksenstad

when nothing is selected at all in the series, it’s treated in a same way as if select all was selected on this filter

[ksenstad]

@duncan

Can you provide a breakdown of how your parent and child filter were created, for example how are you creating the blank by default?

Hello @duncan ,

Sorry not sure I understood the question of “creating blank by default”?

[duncan]

Hey @ksenstad

The main point is how your filter controls are being made. That way I can see if anything needs to be changed to set up the cascading filter.

[duncan]

Hello @ksenstad

Are you able to share you filter set up?