Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
m_fleischmann
New Contributor III

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
Partner
Partner

Re: 2 filters for the same dimension

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

5 Replies
Partner
Partner

Re: 2 filters for the same dimension

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..

m_fleischmann
New Contributor III

Re: 2 filters for the same dimension

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 ❤️

m_fleischmann
New Contributor III

Re: 2 filters for the same dimension

Anyone wanna enhance my understandings how to properly implement filters?

 

Glad for any kind of Response/solution.

Partner
Partner

Re: 2 filters for the same dimension

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

m_fleischmann
New Contributor III

Re: 2 filters for the same dimension

Cheers bro. Easiest way to solve the problem 🙂