Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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
Partner

  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
Partner

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

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

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

View solution in original post

pawwy1415
Creator III
Creator III
Author

Thanks Quy,

Dual() working fine.