Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Custom Sort in List Box

I have a List box with the 9 values. Is there a way to Custom Sort them? So the I can get the list to display specific values before the others??

1 Solution

Accepted Solutions
maxgro
MVP
MVP

another one

9 8 7

then the others (1 2 3 4 5 6) in numeric sort order

104921.jpg

View solution in original post

7 Replies
Nicole-Smith

You can use something like the following in sort by expression:

match(YourListBoxField, 'ValueYouWantSortedFirst', 'ValueYouWantSortedSecond')

and just adapt that to your data (just add more values to the list until you get 9).

Clever_Anjos
Employee
Employee

PFA

iktrayanov
Creator III
Creator III

You can Load inline your values in a specific order and then sort by load order.

Regards,

Ivan

maxgro
MVP
MVP

another one

9 8 7

then the others (1 2 3 4 5 6) in numeric sort order

104921.jpg

View solution in original post

Not applicable
Author

Why is it when I have a value selected, the custom sort order is no longer applied?

So based on your example above, if I have '8' selected, I want the numbers to then be ordered '9 7 1 2 3 4 5 6'

rwunderlich
Luminary Alumni
Luminary Alumni

You have to wrap a bit of Set Analysis around it to ignore the selections.

=only({1}WildMatch(Num,'9','8','7','*'))

-Rob

Not applicable
Author

Similar problem, but solved using  match() function.  Check the blog link

Qlikview Bitz and Pieces: Custom Sort in Qlikview