8 Replies Latest reply: Oct 19, 2016 8:44 AM by xavier hemelaar RSS

    Problem with filter and dimension includinf "if"

    xavier hemelaar

      Hi Qlikers,

      I have created a chart that has a dimension like:

      if(vDim='1','Country', if(vDim='2','city'))

      vDim is set using the extension 'Variable' that allow me to switch in my chart between Country and City.

       

      The problem comes when I select directly on my chart a specific Country. In the filter bar the country will be selected but also the Cities ! But I don't want to have an active filter on the dimension 'City'.

      This is especially problematic when vDim can have 10 different values. I will have 10 filters set a the same time when I Qlik on my chart.

       

      Any idea about how to force Qlik to filter only on the selected dimension?

       

      Thanks