Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pawwy1415
Contributor II

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

Re: Sorting order

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

9 Replies
praveenkumar_ma
Contributor

Re: Sorting order

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

Re: Sorting order

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
Contributor

Re: Sorting order

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
New Contributor II

Re: Sorting order

Hi Kumar,

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

Refer the below application !

pawwy1415
Contributor II

Re: Sorting order

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

Re: Sorting order

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
New Contributor II

Re: Sorting order

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

for example :

Before:

2.PNG

After :

1.PNG

Quy_Nguyen
Contributor III

Re: Sorting order

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

Re: Sorting order

Thanks Quy,

Dual() working fine.