Sorting order

[pawwy1415]

Hi Experts,

Can any one please help me to sort the measure in the expected order as shown in the below image in the attached Sample app.

Thanks in advance.

[praveenkumar_ma]

  Hi kumar,

this might help you , i tried it worked as you expected sorting .

Go to Colors and legend , it is custom

make it auto u can see the sorting as below.

output:

this might helpful.

Thanks

PM

[pawwy1415]

Hi praveenkumar.mallela,

Thanks for your reply. I have changed Colors from custom to Auto but still the sort order not changed.

Could you please provide result in  the sample app .

Thanks in advance

[praveenkumar_ma]

Hi Kumar,

PFA App for your reference.

One more thing want to know which version of Qliksense you are using.

It depends on version also.

And in sorting make all auto sorting for all three fields.

Thanks

PM

[ashwin_r]

Hi Kumar,

Rather than adding an additional dimension, add multiple measures in the order which u needed.

Refer the below application !

[pawwy1415]

Hi Praveen,

Thanks for your reply.

I am using September 2017 version when I have opened the app which you have sent its showing the below result .

Is there any other way to resolve this sorting order .

Thanks in advance.

[pawwy1415]

Hi Ashwin,

By adding individual measure I cant filter the measure that why followed pick method.

As per my requirement user able to filter one measure and sorting order  like above

[ashwin_r]

Then do one thing sort the measures as u needed by promoting

for example :

Before:

After :

[Quy_Nguyen · Accepted solution]

Hi Kumar,

Use this in your Color by Dimension expression:

=Dual(Pick(Dim, 'New Visitors 0-30', 'New Visitors 31-60', 'New Visitors >360'), Dim)

[pawwy1415]

Thanks Quy,

Dual() working fine.