Week() function returns unexpected valueArticle Number: 000041083 | Last Modified: 2019/01/17
If the function returns different values in different Qlik Sense apps, review these variables to make sure the variables are consistent across the apps.
You can also explicitly override the effect of these variables by providing first_week_day, broken_weeks and reference_day arguments directly to the Week() function. For example, the following expressions return fixed values regardless of the 3 environment variables:
- Week('01/01/2016', 0 , 1) returns 1
- Week('01/01/2016', 0 , 0 , 4) returns 53
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.