3 Replies Latest reply: Sep 19, 2012 6:33 PM by Alexander Karlsson RSS

    Inverse the axis

      Hi All,

       

      I have a specific requirement to inverse the Y-Axis.Well let me explain my Point here..i have a chart where i have both +ve and -ve values along Y axis,which is shown as above and below of the 0(zero) respectivly.However,i want the -ve values to be in the above and +ve values to be below of 0.

       

      I do not know if it is possible or not.Would appreciate if any body can answer as soon as possible.

       

      Thanks & Regards,

      Silu_qlikview

        • Re: Inverse the axis
          Sebastian Blum

          Can you just multiply your values by -1?

            • Re: Inverse the axis

              Thanks for your response sebablum.

              If i multiply my value with -1,the value it self will be changed which i do not want rather what i want is,i just want all the positive value will be shown below 0 and all -ve value will be shown above 0.

               

              If i multily with -1 it will be a huge difference to what i want and what it will show..e.g;if some one is having money -20000 that means the person is having a loan of 20000 and if i multiply with -1 the person will have 20000 which contradicts the fact and gives me the wrong data.

               

              Hope i made my point above.

                • Re: Inverse the axis
                  Alexander Karlsson

                  I don't think there is a out of the box setting to do that, sorry.

                   

                  Generally I try to avoid it since it can be pretty confusing depending on the chart audience. I try to stick to visually encoding the +ve/-ve values with color instead depending on the data to try to enforce the message. For financial data that sometimes is a bit tricky...

                   

                  In the attached sample is a small hack to atleast represent the data points as you want them and a graph describing what I was talking about above.