topic Re: Inverse the axis in QlikView

Inverse the axis

Wed, 19 Sep 2012 12:35:24 GMT

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

Wed, 19 Sep 2012 12:41:06 GMT

Can you just multiply your values by -1?

Re: Inverse the axis

Wed, 19 Sep 2012 12:58:53 GMT

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_Thor — Wed, 19 Sep 2012 22:33:52 GMT

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.