Sort the X axis

[Anonymous]

Hey all,

I have a bubble chart currently created:

I would like to inverse the value of my risk axis (x-axis) so they start at 5 and finish at 0.

I have no possibility to define the sort for the X-axis.

Any idea?

[sunny_talwar]

Would you be able to share a sample to try it out?

[Anonymous]

Here in attachment

[sunny_talwar]

See if this approach works for you

[Anonymous]

Hey Sunny,

It's look great.

Can you describe me what you did?

Thank you in advance

[sunny_talwar]

Expression

Dual(

Max ({<SnapShotCalendar.Year={'$(SelectedCalendarYear)'}, SnapShotCalendar.MonthNum={'$(SelectedCalendarMonthNum)'},Stage={'Nego', 'Proposal'}>}[Opportunities.RiskAssessment]),

-Max ({<SnapShotCalendar.Year={'$(SelectedCalendarYear)'}, SnapShotCalendar.MonthNum={'$(SelectedCalendarMonthNum)'},Stage={'Nego', 'Proposal'}>}[Opportunities.RiskAssessment]))

Instead of using positive values, I converted them into negative value, but used dual function to show positive values on the axis. To show positive values on the axis, I had to do this Currency and Other Symbols on the Y-Axis | Qlikview Cookbook

[Sergey_Shuklin · Accepted solution]

Hi, Arnaud!

You may do this little more simplier than Sunny offer.

Go to the Axes tab and remove the check from "Forced to 0" in "X Axis" zone.

Next set a Static Min = 5, Static Max = 0. Your axis will be inversed. See the picture below:

P.S.: I've also entered the Static Step equal minus one - there is no need of it.

[Anonymous]

Hey Sergey,

It works perfectly !

Thank you very much.