Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
swuehl
MVP
MVP

Do you have something like this in mind?

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

sunny_talwar

Something like this?

Capture.PNG

Expression used:

=Dual(Value, -Value)

Only issue might be the axis showing negative numbers

Anonymous
Not applicable
Author

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

swuehl
MVP
MVP

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.

MarcoWedel

Hi,

maybe this helps:

Bar Chart (upside down)

QlikCommunity_Thread_142061_Pic1.jpg

regards

Marco

gmarshall
Partner - Contributor II
Partner - Contributor II

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