topic Re: Reverse max and min value on a chart in QlikView

Reverse max and min value on a chart

Anonymous — Fri, 22 Apr 2016 19:40:13 GMT

Hello,

I'm wondering if it's possible to reverse the axis values on a chart, where the highest value is at the bottom and the lowest value is at the top.

Can this be done?

Re: Reverse max and min value on a chart

swuehl — Fri, 22 Apr 2016 19:43:41 GMT

Do you have something like this in mind?

How can I invert or reverse the axis in my chart?

Re: Reverse max and min value on a chart

sunny_talwar — Fri, 22 Apr 2016 19:45:18 GMT

Something like this?

Expression used:

=Dual(Value, -Value)

Only issue might be the axis showing negative numbers

Re: Reverse max and min value on a chart

Anonymous — Fri, 22 Apr 2016 20:02:58 GMT

Thank you for the reply swuehl! Yes, this is similar to what I'm looking for. Is it possible to put this into a radar chart?

I'm essentially trying to create a bull's eye chart

Re: Reverse max and min value on a chart

swuehl — Fri, 22 Apr 2016 20:13:59 GMT

If I understand your request correctly, I would rather look into a scatter chart.

Maybe I don't, so please post a more complete description of what you want to achieve, maybe some sample lines of records and your expected result e.g. as sketch drawing, too.

Re: Reverse max and min value on a chart

MarcoWedel — Sat, 23 Apr 2016 23:33:47 GMT

Hi,

maybe this helps:

Bar Chart (upside down)

regards

Marco

Re: Reverse max and min value on a chart

gmarshall — Fri, 29 Apr 2016 08:22:56 GMT

If you need to show the values in reverse such as when you RANK() a value then you can use the following. You can use it when only showing a single expression too.