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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
MauriceLudo
Creator II
Creator II

Week 1 janvier

Hi,

how I can make sure that week 1 always start on 01/01 of each year.

Best regards

Maurice

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Calculate the week number like this: Ceil(DayNumberOfYear(MyDateField)/7) as WeekNumber


talk is cheap, supply exceeds demand