topic Change Date to Day name in QlikView

Change Date to Day name

Tue, 06 Dec 2011 09:34:34 GMT

Hi All,

1) I’m trying to change numbers from Days column to a Day name but can’tconverted using below script but failed.

DayName(MakeWeekDate($(TranxYear),num(Mid(Weeks,6),'00'),iterno()-1 )) as DaysName,

2) In this script it will shown day from Monday to Sunday. What if the script for only exclude Saturday and which is the data will shown from Mon,Tue,Wed,Thurs,Fri and Sun?

Please advise me.

Change Date to Day name

Sokkorn — Tue, 06 Dec 2011 09:52:52 GMT

Hi hairulannuar,

Did you try this function yet : WEEKDAY(DateField)

Regards,

Sokkorn Cheav

Change Date to Day name

Tue, 06 Dec 2011 11:40:57 GMT

Try

WeekDay() function that will definately help you.

Regards,

Nitin Jain