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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sorting week days

I have created a listbox with the weekdays. However they are lined in the wrong order. How can I correct this? I tried the sort by expresion option but couldn't succeed to sort them in the correct order. Thanks

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

how are you creating your weekdays?

maybe use Sort by Expression

     =Match(WEEKDAYFIELD,'Mon','Tue','Wed','Thu','Fri','Sat','Sun')

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

10 Replies
tresesco
MVP
MVP

Could you post a sample/screenshot?

vinieme12
Champion III
Champion III

how are you creating your weekdays?

maybe use Sort by Expression

     =Match(WEEKDAYFIELD,'Mon','Tue','Wed','Thu','Fri','Sat','Sun')

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sergio0592
Specialist III
Specialist III

Try with Properties/Sort/Sort by expression

and as expression : index('mon  thue  wed  thur   frid  sat  sun', WeekDayField)

Anonymous
Not applicable
Author

maybe this (sorts correct in my app)

only({1}weekday(yourdatefield))

its_anandrjs
Champion III
Champion III

Better if you add one inline table in your data model and connect the Weekdays field with your Weekdays field in data model this will effective worked here.

WeeDaysSort:

Load * Inline

[

WeekDays,SortOrder

Mon,1

Tue,2

Wed,3

Thu,4

Fri,5

Sat,6

Sun,7

];


Regards

Anand

shraddha_23
Partner - Creator
Partner - Creator

Hi

find attached screenshot

use this expression:- Match(WeekDay,'Mon','Tue','Wed','Thu','Fri','Sat','Sun') in sort tab


Task.JPG

its_anandrjs
Champion III
Champion III

If you required this in the front end UI then better you can do this way on your chart sort properties.

Ex:-

=ONLY( Match( YourWeekDayFieldname,'Mon','Tue','Wed','Thu','Fri','Sat','Sun' ) )


Anonymous
Not applicable
Author

thank you very much

dezmundw15
Contributor III
Contributor III

I was having an issue sorting my date and the formula you provided worked!

Thanks,

Desmond