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.

Not applicable

How to get the day name from a date filed

Hi Guys,

I have a date field in my qlikview sheet.

I want to make the corresponding day name out of it.

like Monday,Tuesday...

Which function i can use to get the day name?

Can somebody help?

Regds,

Sona

3 Replies
MVP
MVP

How to get the day name from a date filed

Hi Sona,

you might use weekday(Date) function to get the Day names. weekday() will return a dual value, i.e. you could use num(weekday(Date)) to retrieve the week day number 0-6.

Day names are retrieved from the script:

Set DayNames = 'Monday;Tuesday;Wednesday;..'

Hope this helps,

Stefan

Not applicable

Re: How to get the day name from a date filed

Hi Praveena,

You can use the  WeekDay() function along with changes in the default DayNames set in the script to achieve this. You can check the attached file

Regards

DS

rajkumart
New Contributor III

Re: How to get the day name from a date filed

WeekDay()