Dynamic Reference line (Based Upon Filter)

Mon, 11 Apr 2016 15:36:55 GMT

Hi All,

I am trying to create a dynamic reference line that will change position based upon the filter(s) selected.

For example, if I select the filter 'Carrot' in the group 'Fuit and Vege' the reference line should be '=10000'. If nothing is selected the reference line should be '=20000', if I Select 'Apple' and 'Carrot' (2 filters) the reference line should be '=15000'.

I am trying to avoid having to change my actual data set to include something that will allocate Carrot to be 10,000 (for example).

Does anyone know the expression I can use within the reference line to create this reference line?

Thanks in advance for your help, and please feel free to ask any questions for clarification!

Re: Dynamic Reference line (Based Upon Filter)

settu_periasamy — Mon, 11 Apr 2016 16:50:48 GMT

May be there is good suggestion.. Try this also. -> Reference lines in the Presentation Tab

=if(GetSelectedCount(Dim)=1 and WildMatch(Dim,'*Carrot*'),10000,
if(GetSelectedCount(Dim)=2 and WildMatch(Concat(DISTINCT Dim,','),'*Carrot*') and
WildMatch(Concat(DISTINCT Dim,','),'*Apple*'),15000,20000))

topic Dynamic Reference line (Based Upon Filter) in QlikView

Dynamic Reference line (Based Upon Filter)

Re: Dynamic Reference line (Based Upon Filter)