Discussion Board for collaboration related to QlikView App Development.
I have following script in my master calendar to create weeks.
'Week'&Ceil(Day(TRN_DATE)/7) as MonthlyWeek,
I note that in the above syntax week start day is Monday. I want to make the start day as Sunday. Kindly help me to modify the script to suit my requirement.
I think you should use the WeekStart function https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFun...
If you don't specify first_week_day, the value of variable FirstWeekDay will be used as the first day of the week.
If you want to use another day as the first day of the week, set first_week_day to:
The integer returned by the function will now use the first day of the week that you set with first_week_day as base (0).
What exactly are you trying to get here? Week Numbers with respect to Months?
Jan 1st - Jan 6th - Week1Jan 7th - Jan 13th - Week2Jan 14th - Jan 20th - Week3Jan 21st - Jan 27th - Week4Jan 28th - Jan 31st - Week5Feb 1st - Feb 3rd - Week1
and so on...?
That is exactly what I want
I have tried with SET FirstWeekDay=0; but it does not work. Kindly advise me.
Could u pls share a sample