topic Re: Custom Listbox Sorting in QlikView

Custom Listbox Sorting

dselgo_eidex — Tue, 18 Jul 2017 14:59:25 GMT

Hello, I have a listbox with values for different Student Grade Levels. I want the listbox to be sorted like below:

I've gotten this sort order by adding a new value to the same table called [Grade Sort] which has a value of 1 for Pre-Kindergarten Half-Day, 2 for Pre-Kindergarten Full-Day, etc. Then on the sort tab of the listbox properties I put this field in the Expression box:

Note: the actual value isn't called [Grade Sort] which is why QlikView is marking it as an incorrect field.

The problem that I am having is whenever I select a value in the list box, the order gets completely screwed up like this:

I want Grade 5 to be at the top because it is the current selection, but the other values should be in the original order. Can anyone explain to me why this is happening and how I can get my desired result?

Re: Custom Listbox Sorting

effinty2112 — Tue, 18 Jul 2017 15:07:43 GMT

Hi Danny,

Try as your sort expression:

=min({1}[Grade Sort])

Good luck

Andrew

Re: Custom Listbox Sorting

effinty2112 — Tue, 18 Jul 2017 15:16:03 GMT

Hi Danny,

What font are you using in your listbox? I like it.

cheers

Andrew

Re: Custom Listbox Sorting

dselgo_eidex — Tue, 18 Jul 2017 15:19:27 GMT

Thanks for the help!

It is HelveticaNeueLTStd57Condensed. I don't know where you would be able to get it though.

Re: Custom Listbox Sorting

effinty2112 — Tue, 18 Jul 2017 15:21:19 GMT

Hi danny,

I'm a big fan of Helvetica - this is one I didn't recognise as one of the Helvetica family at all but was rather taken by it, nice and compact.

Thanks

Andrew