Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS

QlikView : WeekName() shows wrong week number (ISO-8601)

cancel
Showing results for 
Search instead for 
Did you mean: 
Caterina_Fruci
Support
Support

QlikView : WeekName() shows wrong week number (ISO-8601)

In QlikView May 2021 an intentional change was introduced  in the use of the weekname () function to respect local parameters such as FirstWeekDay,  BrokenWeeks  and  ReferenceDay.

 

Environment

 

  • #QlikView

 

Resolution

 

By updating the "SET BrokenWeeks=1;" to "SET BrokenWeeks=0;" in the script,  as shown in ( Fig.1 ) ;

as per " ISO-8601 " (the International Organization for Standardization) , for instance,   the following

date:  1/1/2022  should correspond to the 52nd week of the year 2021 .

 

Fig.1

Caterina_Fruci_0-1649163841940.png

 

Internal Investigation ID(s) 

Tags (2)
Version history
Last update:
‎2022-05-23 03:16 AM
Updated by: