Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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

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