Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Week start date as Sunday

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,

Date

TestDay

TestWeek

TestMonth

2/5/2017

Sunday

5

Feb

2/6/2017

Monday

6

Feb

2/7/2017

Tuesday

6

Feb

2/8/2017

Wednesday

6

Feb

2/9/2017

Thursday

6

Feb

2/10/2017

Friday

6

Feb

2/11/2017

Saturday

6

Feb

2/12/2017

Sunday

6

Feb

Where the first day of the week starts on Monday - 06th Feb.

But I need the date table as below,

Date

TestDay

TestWeek

TestMonth

2/5/2017

Sunday

6

Feb

2/6/2017

Monday

6

Feb

2/7/2017

Tuesday

6

Feb

2/8/2017

Wednesday

6

Feb

2/9/2017

Thursday

6

Feb

2/10/2017

Friday

6

Feb

2/11/2017

Saturday

6

Feb

2/12/2017

Sunday

7

Feb

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?

1 Solution

Accepted Solutions
Highlighted
Master II
Master II

2 Replies
Highlighted
Master II
Master II

Highlighted
Master
Master

Try to also add 1 in BrokenWeeks:

SET FirstWeekDay=6;
SET BrokenWeeks=1;