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

# 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

Can you just multiply your values by -1?

• ###### Re: Inverse the axis

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

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.