Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator 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

Do you have something like this in mind?

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

Something like this?

Capture.PNG

Expression used:

=Dual(Value, -Value)

Only issue might be the axis showing negative numbers

Creator II
Creator II

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

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.

Hi,

maybe this helps:

Bar Chart (upside down)

QlikCommunity_Thread_142061_Pic1.jpg

regards

Marco

Partner
Partner

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