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

Current selection box is not displaying month in proper order

Hi All,

I have attached a sample application, It opens with default selection of completed months of current year(2012- Jan, Feb, Mar, Apr, May). Functionality is working properly, but in the current selection box , it displays the month in alphabetic order(Apr, Feb, Jan, Mar, May). How can i fix this? Please provide a solution.

Regards,

Gerard

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Gerard,

use a sort-weight for the concat function in your OnOpen action, like

='('&concat(DISTINCT {<Month={"<$(=Num(Month(Today())))"}>} Month,'|',MonthKey)&')'

View solution in original post

2 Replies
swuehl
MVP
MVP

Gerard,

use a sort-weight for the concat function in your OnOpen action, like

='('&concat(DISTINCT {<Month={"<$(=Num(Month(Today())))"}>} Month,'|',MonthKey)&')'

Not applicable
Author

Hi,

Thanks the expression is working and it is perfect.

Regards,

Gerard