Discussion Board for collaboration on QlikView Layout & Visualizations.
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,
Go to Solution.
Works for me. Make sure you put the expressions on the correct (left or right) axis.
See attached example.
Multiply with -1 in your expression Or use function "Fabs" to convert them in positve number.
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.
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...)...
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
All properties of two bars are the same
Works for me with two bar expressions too. See the example I attached in my previous post.