Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
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

Re: Overlapping conditions as flags/filter

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

Re: Overlapping conditions as flags/filter

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

Re: Overlapping conditions as flags/filter

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

Re: Overlapping conditions as flags/filter

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.