Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Reverse chart axis

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:

Безымянный.png

Thanks in advance,

Kristina

1 Solution

Accepted Solutions

Re: Re: Reverse chart axis

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


talk is cheap, supply exceeds demand
8 Replies

Re: Reverse chart axis

See attached example.


talk is cheap, supply exceeds demand
satyadev_j
Valued Contributor

Re: Reverse chart axis

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

Sum(Value)*-1

Fabs(Sum(Value))

ravic906
Contributor III

Re: Reverse chart axis

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.

Not applicable

Re: Reverse chart axis

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

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


talk is cheap, supply exceeds demand
Not applicable

Re: Re: Reverse chart axis

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

Not applicable

Re: Re: Reverse chart axis

All properties of two bars are the same

Re: Reverse chart axis

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


talk is cheap, supply exceeds demand
Community Browser