Skip to main content
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