Discussion board where members can get started with QlikView.
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