1 Reply Latest reply: Mar 8, 2017 7:00 PM by Ajit Limaye RSS

    Qlik Sense Scatter Chart Dynamic Reference Line

    Kevin Warren

      Hello,

       

      I am looking for a solution to make my reference lines within my scatter chart change dynamically based on the in chart measures chosen for the X and Y-Axis's.

       

      I can set a static expression for the current Axis Measure Displayed, but when I select an Alternative Measure to display with the dropdown option, I would like the reference line to change dynamically to reflect the new dropdown selection measure.

       

      Scatter Chart Dynamic Reference Line Expression Help.PNG

        • Re: Qlik Sense Scatter Chart Dynamic Reference Line
          Ajit Limaye

          Kevin,

           

          Using this function (GetObjectMeasure(index)) you can get the first (index being 0) or second (index being 1) measure. It tells you the actual label string value. I then tried to get length since reference line requires a numeric value.

          I renamed your first measure as ABCD and second as AB. I was hoping a simple IF condition can then be used to evaluate which one is selected.

          scatter-reference.JPG

           

          It works in the Pivot Table but somehow not when evaluating in the reference line expression. Please let us know if you can experiment a bit more and get it working.

           

          thanks,

          Ajit