Discussion board where members can get started with Qlik Sense.
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.
i think, you should create the flags in script, it it the best way to create then the filter on UI (Userinterface)
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.
Can you give me your example data, i create an example and send it to you
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.
I solved this with an extension.