Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siddharth_s2
New Contributor III

Filtering

Hello all,

I need some assistance in helping me with the below problem. Please note that I am using Qlik Sense

I have a set of 100 customers which have been divided into focus 3 & focus 5. Let me give an example:

Focus 3 Customers: Lenovo, Dell, HP.

Focus 5 Customers: Above 3 customers + Acer + Motorola.

I have created a dimension which is an If loop. Something like this.

IF(Customer='Lenovo' OR Customer = 'Dell' OR Customer = 'HP', 'Focus 3', IF(Customer = 'Acer' OR Customer = 'Motorola', 'Focus 5','No Focus'))

This is as a filter field.

Now if a user clicks on focus 5, how can I filter the focus 3 and the remaining too?

Thanks in advance.

Tags (1)
5 Replies
beck_bakytbek
Valued Contributor III

Re: Filtering

Hi Siddharth,

i think, you should create the flags in script, it it the best way to create then the filter on UI (Userinterface)

Beck

siddharth_s2
New Contributor III

Re: Filtering

The formula I mentioned above is a dimension I have created in the script.

The problem with that is if someone clicks on focus 5 then only 2 customers (Acer and Motorola) are selected and not all 5 which is the way it should be.

So I was checking if there is any alternative.

beck_bakytbek
Valued Contributor III

Re: Filtering

Can you give me your example data, i create an example and send it to you

agigliotti
Honored Contributor II

Re: Filtering

i suggest you to add the below script:

IF(Customer='Lenovo' OR Customer = 'Dell' OR Customer = 'HP', 'F3', IF(Customer = 'Acer' OR Customer = 'Motorola', 'F5' ) as FocusGroup


then create the table below:

FocusGroup - Focus

F3                   focus 5

F5                   focus 5

F3                   focus 3


finally uses "Focus" as dimension in your chart object.

siddharth_s2
New Contributor III

Re: Filtering

Thanks all,

I solved this with an extension.

Community Browser