Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Overlapping conditions as flags/filter

Hello. I have a bit of an odd task to show a filter with fieldname COST values qualifying following conditions:

  • All (they want to see this anyway)
  • > $500
  • > $10000

I ended up creating 3 separate flag fields (FlagALL, Flag750, Flag10k) on load script as the above values overlap. How do I make this work using a filter pane or a dropdown button calling 3 separate flag fields to accomplish each call? Thanks for your help.

4 Replies
Highlighted
Creator II
Creator II

Hi,
I think you probably need use extension for the 3 values selection.
(e.g. Variable Input:https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Visualizations/Dashb...)

ZZ
Highlighted
Partner
Partner

Create an inline table:

Load * inline [

dimID, Dim

1, ALL

2, $500

3,>$10000

];

Put this new field "Dim" as a filter in ur sheet.

Then in your chart, change ur measure as follow:

 

if(dimID=2,sum({<Flag750={1}>}Measure),

if(dimID=3,sum({<Flag10k={1}>}Measure),

sum({<FlagALL={1}>}Measure)

))

and as a label : 

if(dimID=2,'750',

if(dimID=3,'10k',

'ALL'

))

 

With this,depends on ur selction, u'll call the right Flag.

Highlighted
Contributor II
Contributor II

I tried using variable input (dropdown) but yet to have a working expression to call each of the options required. An example would be helpful. Thanks.

Highlighted
Contributor II
Contributor II

Thanks, i could make it work in charts, label, kpi, but i need it as a standard filter pane or dropdown extension if have to. An example would be helpful.