Solved: Re: Week start date as Sunday - Qlik Community

Report Inappropriate Content · ‎2017-04-10

Hello,

In my script, I have formatted the date as below:

([Date]),

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 - 06^th Feb.

But I need the date table as below,

The first day of week needs to starts on Sunday – 05^th Feb.

I have tried (SET FirstWeekDay=6;)

But it is not working. Can someone help me on it?

Frank_Hartmann · ‎2017-04-10

This might be helpful:

Frank_Hartmann · ‎2017-04-10

This might be helpful:

stabben23 · ‎2017-04-10

Try to also add 1 in BrokenWeeks:

SET FirstWeekDay=6;
SET BrokenWeeks=1;