Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bibopipo
Contributor II

week days order

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

1 Solution

Accepted Solutions
MVP
MVP

Re: week days order

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.

4 Replies
MVP
MVP

Re: week days order

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.

Re: week days order

HI

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

or

Sort ->expression

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

bibopipo
Contributor II

Re: week days order

Thanks!!!

Not applicable

Re: week days order

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

Community Browser