topic Re: Sorting week days in QlikView

Sorting week days

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Sorting week days

tresB — Mon, 28 Aug 2017 11:15:08 GMT

Could you post a sample/screenshot?

Re: Sorting week days

vinieme12 — Mon, 28 Aug 2017 11:20:29 GMT

how are you creating your weekdays?

maybe use Sort by Expression

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

Re: Sorting week days

sergio0592 — Mon, 28 Aug 2017 11:26:09 GMT

Try with Properties/Sort/Sort by expression

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

Re: Sorting week days

Anonymous — Mon, 28 Aug 2017 11:26:17 GMT

maybe this (sorts correct in my app)

only({1}weekday(yourdatefield))

Re: Sorting week days

its_anandrjs — Mon, 28 Aug 2017 11:40:14 GMT

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

Re: Sorting week days

shraddha_23 — Mon, 28 Aug 2017 12:05:22 GMT

find attached screenshot

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

Re: Sorting week days

its_anandrjs — Mon, 28 Aug 2017 12:13:29 GMT

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' ) )

Re: Sorting week days

Anonymous — Mon, 28 Aug 2017 13:08:44 GMT

thank you very much

Re: Sorting week days

dezmundw15 — Wed, 23 May 2018 22:00:39 GMT

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

Thanks,

Desmond

Re: Sorting week days

dezmundw15 — Wed, 23 May 2018 22:04:14 GMT

Just an addendum to my response. I was having issues with sorting my Week_Day Field in a Pivot Table that I developed. I used the formula while expanding the naming convention of the day as follows:

=ONLY( Match( YourWeekDayFieldname,'Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday' ) )