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

[Caterina_Fruci]

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

Internal Investigation ID(s) 

• QV-23259