topic Re: Reverse chart axis in QlikView

Reverse chart axis

Fri, 27 Jun 2014 08:42:00 GMT

Hi Experts!

I have a simple chart with negative points on it. I want to keep them, but need to invert Y-axis, like they are positive, but keeping the minus-symbol:

Thanks in advance,

Kristina

Re: Reverse chart axis

Gysbert_Wassenaar — Fri, 27 Jun 2014 09:22:11 GMT

See attached example.

Re: Reverse chart axis

Anonymous — Fri, 27 Jun 2014 09:31:36 GMT

Multiply with -1 in your expression Or use function "Fabs" to convert them in positve number.

Sum(Value)*-1

Fabs(Sum(Value))

Re: Reverse chart axis

Anonymous — Fri, 27 Jun 2014 10:05:13 GMT

Hi,

Your idea seems to violate co-ordinate geometry. Its not right to have a negative axis on the postive side.

Still, if you are too desperate then follow the above suggestions.

HTH

Ravi N.

Re: Reverse chart axis

Fri, 27 Jun 2014 10:49:06 GMT

Thank you, Gysbert!

This works great for one expession, but if I add second one, it shows strange numbers (1,0;0,8;0,6....etc instead of 25 000; 20 000; 15 000...)...

Re: Re: Reverse chart axis

Gysbert_Wassenaar — Fri, 27 Jun 2014 11:05:36 GMT

Works for me. Make sure you put the expressions on the correct (left or right) axis.

Re: Re: Reverse chart axis

Fri, 27 Jun 2014 11:08:01 GMT

Yes, it works perfect for me too, only if i have one visible bar and one invisible line. But when i add second visible bar, it goes wrong

Re: Re: Reverse chart axis

Fri, 27 Jun 2014 11:08:53 GMT

All properties of two bars are the same

Re: Reverse chart axis

Gysbert_Wassenaar — Fri, 27 Jun 2014 11:09:30 GMT

Works for me with two bar expressions too. See the example I attached in my previous post.