Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello. I have a bit of an odd task to show a filter with fieldname COST values qualifying following conditions:
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.
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.
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.
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.