topic Re: Listbox - Select in place with expression sort in QlikView

Listbox - Select in place with expression sort

Fri, 22 Aug 2014 13:00:01 GMT

I'm trying to understand what's going on with listbox sorting in this situation...

I have a list of months like so:

MonthsOfYear:

LOAD * INLINE [

Month, MonthNo

Jan, 1

Feb, 2

Mar, 3

[etc.]

and a Month listbox. The sort is on Auto Ascending, so that selections are made in place and the unselected entries remain static (don't move). This works fine, but as soon as I add a sort expression (on MonthNo -- to sort the entries chronologically), this behavior changes. Selections move to the bottom of the listbox, and the unselected entries re-sort themselves in an unexpected way. I want a chronological sort and static selection behavior.

See attached for a distilled example. Can someone help?

Re: Listbox - Select in place with expression sort

Gysbert_Wassenaar — Fri, 22 Aug 2014 13:12:52 GMT

Change the sorting expression to only({1}MonthNo) so that a selection doesn't influence the sorting expression.

Re: Listbox - Select in place with expression sort

Fri, 22 Aug 2014 14:38:40 GMT

Yes, that works. Thank you. I need to spend some time now understanding the logic behind it...