1 Reply Latest reply: May 2, 2018 10:14 AM by Justin Dallas RSS

    Area difference chart

    Bhawana Choudhary

      Hi All,

       

      I want to achieve the below visualization in qlik sense:

       

      image.png

       

      In this area chart there y axis will start from 0 only but the reference line is 3  and we have to represent if the point is above 3 than area between that point and 3 should be blue and if its less than 3 than it should be red .

      Any suggestion which extension I cna use as tried with line chart but not able to achieve .

        • Re: Area difference chart
          Justin Dallas

          Test Data:

           

          TestTable:
          LOAD * Inline
          [
          'XValue', 'YValue',
              1, 25
              2, 21
              3, 19
              4,10
              5, 5
              6,3
              7,-4
              8,-8
              9,-15
              10, -16
              
          ]
          ;
          
          
          EXIT Script
          ;
          

           

           

          Add a Line Chart to your sheet, using the Xvalue and Yvalue for the dimension and measure.

          QHelp1.PNG

           

           

          In the Chart > Appearance > Presentation, select Area.

           

          QHelp2.PNG

           

          In Appearance > Colors and Legend, select 'Custom' and 'By measure'.

           

          QHelp3.PNG

           

          Click the fx and input

           

          =If( YValue > 0, blue(), red() )

           

          QHelp4.PNG

           

          QHelp5.PNG