Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Dynamic Filter selection to show measures

Hi All,

I taken inline load, with field Filter and values are sellin, sellout,Quantity. I taken a (Grouped)bar chart with 3 measures sum(sellin),Sum(Sellout),sum(Quantity) and Date as dimension

i taken that filter with 3 values as button. when no selection, all 3 bars to be appear in chart. when any one selected only that bar to be appear, if any two selected those two bar to be appear on the bar chart.

I write calculation condition as if(GetselectedCount(Filter)=0, or Getfieldselections(Filter)='Sellin',1,0)  works fine for single selection and no selction in filter buttons. 

Please tell me how to write calculation condition when sellin and sellout button are slected  from filter. that time user want to see two bars (sellin and Sellout Bars) on chart

Labels (1)
1 Reply

Try this

=GetSelectedCount(Filter)=0 OR wildmatch(GetCurrentSelections( Filter, '|'),'*Sellin*')