Discussion board where members can get started with QlikView.
In my script, I have formatted the date as below:
DayName([Date]) as TestDay, Week([Date]) as TestWeek, Month([Date]) as TestMonth,
And my date table looks like below,
Where the first day of the week starts on Monday - 06th Feb.
But I need the date table as below,
The first day of week needs to starts on Sunday – 05th Feb.
I have tried (SET FirstWeekDay=6;)
But it is not working. Can someone help me on it?
This might be helpful:
Week Start - Sunday instead of Monday
View solution in original post
Try to also add 1 in BrokenWeeks:
SET FirstWeekDay=6; SET BrokenWeeks=1;