topic Re: Sort the X axis in QlikView

Sort the X axis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Sort the X axis

sunny_talwar — Mon, 08 May 2017 11:52:15 GMT

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

Re: Sort the X axis

Anonymous — Mon, 08 May 2017 12:03:51 GMT

Here in attachment

Re: Sort the X axis

sunny_talwar — Mon, 08 May 2017 12:10:51 GMT

See if this approach works for you

Re: Sort the X axis

Anonymous — Mon, 08 May 2017 12:36:47 GMT

Hey Sunny,

It's look great.

Can you describe me what you did?

Thank you in advance

Re: Sort the X axis

sunny_talwar — Mon, 08 May 2017 12:39:44 GMT

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

Re: Sort the X axis

Sergey_Shuklin — Mon, 08 May 2017 15:37:31 GMT

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.

Re: Sort the X axis

Anonymous — Tue, 09 May 2017 07:31:32 GMT

Hey Sergey,

It works perfectly !

Thank you very much.