Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MK_QSL
MVP
MVP

WeekNum

How to get week numbers from date considering

Week Starts from Saturday...

Week Starts from Sunday..

Week Starts from Monday

Need for all three..

1 Solution

Accepted Solutions
3 Replies
tresesco
MVP
MVP

Try:

Week(WeekStart(YourDate,6))  // starts Saturday

Week(WeekStart(YourDate,7))  // starts Sunday

Week(WeekStart(YourDate))  // starts Monday  , in fact simply week(Yourdate) should work

hic
Former Employee
Former Employee

MK_QSL
MVP
MVP
Author

Dear Henric,

Excellent blog... Thanks for your help.