1 Reply Latest reply: Jul 4, 2018 4:26 PM by Mikael Scorielle RSS

    Bar Chart: Show different reference line according to selected dimension

    Kevin Falkenstein

      Hello everyone,

       

      is it possible to change the value of a reference line in a bar chart according to the selected dimension?

       

      I was looking for something like a formular for the reference line, i.e.

      if(selectedDimension = Category, 2000, if(selectedDimension = Country, 4000, 0)

       

      Right now, I have naively "solved" this with two reference lines, but obviously this is a bad solution.

       

      QlikSense.PNG

       

      Any ideas for a solution would be nice.

       

      Thank you