Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Contact
Find Answers
Join Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Get Support
Have a Question?
Search Qlik's Support knowledge database or request assisted support for your highly complex issues.
Submit a Case
Talk with a Representative
Critical Issues
Experiencing a serious product issue? Please Contact us by phone. Click here to view phone numbers and hours by region.
Contact UsWelcome Guest
Installed Qlik Products
My Environments
Log your environments to ensure faster and more targeted troubleshooting.
View Available Licenses
My Licenses
Understand your licenses to help you maximize your experience.
Knowledge
1st week of the year in week() function
Article Number: 000003721 | Last Modified: 2019/01/17Description
QlikView uses ISO 8601 to calculate week number. (See http://en.wikipedia.org/wiki/ISO_week_date)
In short, it defines that the first week of the year is the week contains January 4th.
week() function precisely does that.
...
But sometimes, we want December 30 or 31 to be the Week 53, instead of the Week 01 in that case.
How can we do that?
In short, it defines that the first week of the year is the week contains January 4th.
week() function precisely does that.
...
But sometimes, we want December 30 or 31 to be the Week 53, instead of the Week 01 in that case.
How can we do that?
Resolution
If you want Sunday as the first day of the week, you can use
Div(date-YearStart(date) + WeekDay(YearStart(date)+1) +7,7) as WeekNumber
Source:
http://community.qlikview.com/thread/61509
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.