Overlapping conditions as flags/filter

[Anonymous]

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.

[zzyjordan]

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

[OmarBenSalem]

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.

[Anonymous]

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.

[Anonymous]

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.