Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Listbox - Select in place with expression sort

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?

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand
Not applicable
Author

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