Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

10 Replies
Not applicable
Author

Thanks for the soluion, it works perfectly