topic Re: Custom Sort in List Box in QlikView

Custom Sort in List Box

Tue, 21 Jan 2014 19:46:37 GMT

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 — Tue, 21 Jan 2014 19:48:05 GMT

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 — Tue, 21 Jan 2014 19:54:56 GMT

PFA

iktrayanov — Tue, 21 Jan 2014 19:56:40 GMT

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

Regards,

Ivan

maxgro — Tue, 21 Jan 2014 20:14:58 GMT

another one

9 8 7

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

Mon, 10 Mar 2014 22:20:15 GMT

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 — Mon, 10 Mar 2014 22:52:02 GMT

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

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

-Rob

Thu, 03 Apr 2014 19:37:47 GMT

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