Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Reverse of Axis should in the Positive number

Hi Experts,

I have Reserve, Target and  achievement values.

Reserve is indicated with Dark Gray color and   Target with light gray and Dot symbol achievement.While im trying to reverse the axis getting -ve value,tried using Fabs and * - ,but no luck.we need axis like 8,6,4 etc + positive value

Below is my chart and attached the raw data and qlikview application

Graph.png

Could you please suggest me the better solution

In Advance thank you

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like attached?

View solution in original post

5 Replies
roger_stone
Creator III
Creator III

Your first three expressions all multiply by minus 1. Remove that multiplier and they will be positive numbers.

roger_stone
Creator III
Creator III

Like this?

Anonymous
Not applicable
Author

Experts,

Need experts suggestion here

If i remove the *-1 then output is looking like

Graph.png

I want the reverse of the axis like 8 % ,6% and 0% like.Is any thing wrong in the number format pattern ?

Graph.png

swuehl
MVP
MVP

Maybe like attached?

Anonymous
Not applicable
Author

Perfect .Thank you expert