topic week days order in QlikView

week days order

Anonymous — Tue, 04 Dec 2012 22:54:20 GMT

Dear all,

how can I order the days of week ? I've a graph and I would display the names of the days in order as they are in the week:

Mon Tue Wed Thu Fri Sat Sun

I retrieved the names by the weekday function, but they aren't in the right sequence.

Is it possible ?

Thanks in advance for your help

swuehl — Tue, 04 Dec 2012 22:58:24 GMT

Weekday() should have created dual values with a numeric representation which you could use to sort your values.

In your chart, select numeric as sort order in sort tab.

MayilVahanan — Tue, 04 Dec 2012 22:59:27 GMT

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Sort ->expression

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

Anonymous — Tue, 04 Dec 2012 23:35:14 GMT

Thanks!!!

Wed, 01 Feb 2017 15:41:20 GMT

The second option works great for me. I just needed to capitalize them to match my existing day characters. Thanks much!