Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pawwy1415
Creator III
Creator III

Sorting order

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.

sorting.png

Thanks in advance.

1 Solution

Accepted Solutions
Quy_Nguyen
Specialist
Specialist

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)

bt.PNG

View solution in original post

9 Replies
praveenkumar_ma
Partner - Creator
Partner - Creator

  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
Creator III
Creator III
Author

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
Partner - Creator
Partner - Creator

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
Contributor III
Contributor III

Hi Kumar,

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

Refer the below application !

pawwy1415
Creator III
Creator III
Author

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.

test.png

pawwy1415
Creator III
Creator III
Author

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

MEASURE FILTER.png

ashwin_r
Contributor III
Contributor III

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

for example :

Before:

2.PNG

After :

1.PNG

Quy_Nguyen
Specialist
Specialist

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)

bt.PNG

pawwy1415
Creator III
Creator III
Author

Thanks Quy,

Dual() working fine.