Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
napac1458
Contributor II

Reverse max and min value on a chart

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?

6 Replies
MVP
MVP

Re: Reverse max and min value on a chart

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

Something like this?

Capture.PNG

Expression used:

=Dual(Value, -Value)

Only issue might be the axis showing negative numbers

napac1458
Contributor II

Re: Reverse max and min value on a chart

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

MVP
MVP

Re: Reverse max and min value on a chart

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

Hi,

maybe this helps:

Bar Chart (upside down)

QlikCommunity_Thread_142061_Pic1.jpg

regards

Marco

gmarshall
New Contributor II

Re: Reverse max and min value on a chart

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.reversed scale option chart.png

reversed scale option.png