Threaded filter / cascade filter

Question & Answer
, , , , ,
1

Hello again,

How to make a cascade filter, that is, apply successive filters based on previous selections?

Best Regards,
July

2

Hi @July
Please have a look at

BR

2 Likes
3

Hi @ErikG

This documentation was not enough.
For example, I have 4 filters, data, category, product and cluster.
These filters are applicable to all visuals.
I need that when the user filters the date, the following filters only show the filter data according to the first filter, and so on.
Could you give me more details with images, please?
Thank you so much

4

Hi @July
What do you mean with “not enough”?

Maybe I don’t get your requirement right. But cascading filter is exactly doing that. Filter category would only show relevant values based on filter date.
BR

1 Like
5

Hello @ErikG

I’m sorry. I was confused.
I will try to do it.

Thank you

6

Hi @ErikG

Can’t I do a cascading filter if the field is a calculated field?

7

Hi @July
you should be able to use cascading filter with calculated fields aswell.
BR

8

Hi @ErikG

This does not work.
For example, I have a product field, which is an integer, such as (1, 2, 3). With this field I can do the cascading filter, but when I try to put the filter on a calculated field to bring up the product description, it doesn’t work.

Example:

switch (product,
1, ‘Product 1’,
2, ‘Product 2’,
‘Others’
)

This calculated field does not work in cascade filter.

9

Did you create the calculated field on datasets or analysis level?

10

At the analysis level.
Why? Does this make a difference?

11

Yes. I would try it with a dataset field two.

12

At the dataset level, the switch function does not exist.

13

Is your switch definition complex? If not you could you ifelse as well.

1 Like
14

Hi @July
did you find a solution?
BR

15

Hi @ErikG
I got it at the dataset level, using the ifelse function.
Tks

1 Like