Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

2 filters for the same dimension

Hi everyone,

 

I wanted to implement two filters for the same dimensions on one page. Now I'm desperately trying to figure out how to seperate these filters from each other.  When I start filtering both filters apply the chosen dimensions but I would like to be able to do the following:

For instance, filter Options: A, B, C, D

FILTER                               FILTER

   A                                           A, B, C, D

 

Is there an easy way to do this? Thanks for your answers in advance and have a nice Weekend 🙂

1 Solution

Accepted Solutions
ggijben
Partner - Creator II
Partner - Creator II

I think your best bet is to make a copy of the field in your script, and use that as 2nd filter.

View solution in original post

5 Replies
OmarBenSalem

u can create 2 new fields based on this:

 

filter 1: if(dim='A',dim,null())

filter2: if(dim<>'A',dim,null())

 

and use these 2 new filters;

BUT, u can't include these in set analysis..

Anonymous
Not applicable
Author

hey man,

thanks for your quick and comprehensive response. Nevertheless I seemingly still have a problem I have to figure out. Maybe I articulated myself a bit wrong.

Concrete example: 

Dimension: A with expressions: 1, 2, 3, 4,

Filter 1:  select 1, 2

Filter 2: No selection except I choose something Manual

Filter 1: if(dim='A',dim,null())

Filter2: if(dim<>'A',dim,null())

Thanks again for helping me out ❤️

Anonymous
Not applicable
Author

Anyone wanna enhance my understandings how to properly implement filters?

 

Glad for any kind of Response/solution.

ggijben
Partner - Creator II
Partner - Creator II

I think your best bet is to make a copy of the field in your script, and use that as 2nd filter.

Anonymous
Not applicable
Author

Cheers bro. Easiest way to solve the problem 🙂