Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jonbmorrison
New Contributor III

Sense Scatterplot - sorting x axis values descending order

It must be possible, just haven't figured out how to make it happen.

Have 1 dimension (company) and 3 measures.

1 on X axis, 1 on Y axis and the 3rd sizes the bubble on the scatterplot diagram

What I'm trying to do

Y axis value - bigger number is better - ascending is preferred.

X axis value - smaller number is better - descending is preferred

     - so upper right is better and lower left is worse.

However, the chart is sorting X axis in ascending order -  my users have asked to sort as per above.

How can this be done.

Qlik Sense September 2017.

I've looked at Scatter plot properties ‒ Qlik Sense and https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Visualizations/change-sorting...

And haven't figured it out - any guidance would be appreciated!

Thank you

1 Solution

Accepted Solutions

Re: Sense Scatterplot - sorting x axis values descending order

Hi,

What i understand is you want to reverse the axis values. If yes then try below.

1. Multiply your expression with -1.

2. For the same expression, Select number formatting as number and switch off the "Formatting Simple". Once you do this it will give you an option to change the formatting. Replace existing formatting with "#,##00;#,##00".

Hopw this work around will help.

Regards,

Kaushik Solanki

3 Replies

Re: Sense Scatterplot - sorting x axis values descending order

Hi,

What i understand is you want to reverse the axis values. If yes then try below.

1. Multiply your expression with -1.

2. For the same expression, Select number formatting as number and switch off the "Formatting Simple". Once you do this it will give you an option to change the formatting. Replace existing formatting with "#,##00;#,##00".

Hopw this work around will help.

Regards,

Kaushik Solanki

jonbmorrison
New Contributor III

Re: Sense Scatterplot - sorting x axis values descending order

Worked perfectly.  Had tried the x -1 but hadn't thought through using the formatting to reverse the sign reversal a second time.

Many thanks!

Re: Sense Scatterplot - sorting x axis values descending order

Even I got this idea from some old Qlikview Post...

Cheers..

Regards,

Kaushik Solanki

Community Browser