Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reverse negative chart

Dear all

Does anyone know how to reverse a chart?

I have negative figures and I would like to show the chart/axes upside down.

This is how I have it in Qlikview right now:

chart1.jpg

this is how I would like to have it

chart2.jpg

Tnx!

/Markus

1 Reply
Not applicable
Author

Hi,

I think there is no regular option to invert the axis.

What you can try is to invert the expression by multiplying it with -1

For example like  sum(value)*-1

Then you format the number to "Currency" with the format -#.##0;#.##0 so that the positive values are shown as negative values.

But this only works for the values in the chartline (for example on mouseover) and not for the axis.

Regards,

Björn