
Not applicable
2011-09-28
08:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Tags:
- new_to_qlikview
3 Replies


MVP
2011-09-28
08:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
2011-09-29
02:07 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

Partner - Contributor III
2018-06-20
04:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
WeekDay()
14,040 Views
