Custom Sort in List Box

[#1]

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

[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]

PFA

[iktrayanov]

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

Regards,

Ivan

[maxgro · Accepted solution]

another one

9 8 7

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

[#6]

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]

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

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

-Rob

[#8]

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

Qlikview Bitz and Pieces: Custom Sort in Qlikview