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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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

1 Solution

Accepted Solutions
sunny_talwar

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

Make sure you have this set statement in your load script

SET FirstWeekDay=6;

MK_QSL
MVP
MVP

Chanty4u
MVP
MVP

swuehl
MVP
MVP

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;

??