I have a date field in my qlikview sheet.
I want to make the corresponding day name out of it.
Which function i can use to get the day name?
Can somebody help?
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,
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
Retrieving data ...