1 Reply Latest reply: Aug 16, 2011 7:55 AM by Björn Brauner RSS

    Reverse negative chart

      Dear all

      Does anyone know how to reverse a chart?

      I have negative figures and I would like to show the chart/axes upside down.

      This is how I have it in Qlikview right now:

       

      chart1.jpg

      this is how I would like to have it

       

      chart2.jpg

       

      Tnx!

       

      /Markus

        • Reverse negative chart

          Hi,

           

          I think there is no regular option to invert the axis.

           

          What you can try is to invert the expression by multiplying it with -1

           

          For example like  sum(value)*-1

           

          Then you format the number to "Currency" with the format -#.##0;#.##0 so that the positive values are shown as negative values.

           

          But this only works for the values in the chartline (for example on mouseover) and not for the axis.

           

          Regards,

          Björn