Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Day Of Week

Hi All

I have list boxes for Year and Month. I would now like to create one for "Day of Week" containing "Monday" to "Sunday" as values.

What function can I use for this?

1 Solution

Accepted Solutions
Highlighted

Re: Day Of Week

To get only one value per day of week in chronological order you could use:

=Dual(Date(Date,'WWWW'), WeekDay(Date))

7 Replies
Employee
Employee

Re: Day Of Week

There is a date mask to use.  'WWW' will return  Mon,Tue, Wed.   'WWWW' will return the full word Monday, Tuesday...

Pass the 'WWW' mask to the function date() to render a date in this format.

=Date(Date,'WWWW')

jpapador
Valued Contributor

Re: Day Of Week

DayName(DateField)

Re: Day Of Week

WeekDay()

Not applicable

Re: Day Of Week

Hi Jonathan

Thanks for your answer. I have applied your method and now it shows a lot of random weekdays.

I would only like it to show Monday, Tuesday, Wednesday, Thursday, Friday, Saterday and Sunday.

Highlighted

Re: Day Of Week

To get only one value per day of week in chronological order you could use:

=Dual(Date(Date,'WWWW'), WeekDay(Date))

Not applicable

Re: Day Of Week

WeekDay returns an interger

Re: Day Of Week

Does it?

QlikCommunity_Thread_144526_Pic1.JPG.jpg