4 Replies Latest reply: Mar 3, 2016 11:00 AM by Ankit Luthra RSS

    Reference Line Expression in Gauge

    Ankit Luthra

      Hello,

       

      QlikSense noob here. I have a Gauge chart that shows % of Female out of Total. I have added a reference line to show a "target" of 50%.

       

      Now, I am trying to make this a dynamic target instead of a static 50% target. I would like to have this target change when I select a particular Job Level in a Filter Pane.

       

      For Example, when I select Job Level='Executive', I want this target/reference line to be 27%, similarly when I select Job Level='Director' it changes to 40% and so on. How can I do this in the Gauge chart? I am guessing via the Reference Line Expression?

       

      I tried applying the formula below but it didn't work. I am sure I am doing something wrong:-

       

      = IF ({<[Job Level] = {'Executive'}>}[ID],27, [,50])

       

      Thoughts?

       

      Thanks!

      Ankit