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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-01-26 01:15 AM

Sorting by Expression

Hi All

I have a list box showing Weekly dates(from-to), week number in the month and month of the week.

2015-01-26_07-59-13.png

I have written a sort expression to sort by week number "mid(Weeks,12,1) ". I would now like to have a second condition in the sort expression to will sort first by week number, then months in a cronological order. How can I do this?

I would also like my selected dates to show at the top of the list box as they currently at the bottom which I need to scroll down to see.

2015-01-26_08-12-20.png

1,854 Views
0 Likes
10 Replies
Not applicable
‎2015-01-27 04:16 PM
Author

In response to rwunderlich

Thanks for the soluion, it works perfectly

113 Views
0 Likes