Reverse negative chart

Tue, 16 Aug 2011 09:45:42 GMT

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:

this is how I would like to have it

Tnx!

/Markus

Tue, 16 Aug 2011 11:55:20 GMT

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

topic Reverse negative chart in QlikView