Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

week function problem

I am using the week function to get the number of week of the year,

but I need that the starting point of a week be Monday not Sundat in order to count weeks

Can I change this?

Thanks in advance

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

Make sure you have this set statement in your load script

SET FirstWeekDay=6;

View solution in original post

7 Replies
Chanty4u
MVP
MVP

agustinbobba
Partner - Creator
Partner - Creator

Hi Juan,

Try Use WeekStart function

Best regards

Agustin

sunny_talwar
MVP
MVP

Make sure you have this set statement in your load script

SET FirstWeekDay=6;

MK_QSL
MVP
MVP

Chanty4u
MVP
MVP

swuehl
Champion III
Champion III

Which QV version are you using?

Have a look also at

Redefining the Week Start

alexis
Partner - Specialist
Partner - Specialist

Should the solution for setting the first day  of the week to Monday not be

SET FirstWeekDay = 0;

instead of the suggested 

FirstWeekDay=6;

??