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

Caterina_Fruci — Mon, 23 May 2022 07:16:57 GMT

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

article QlikView : WeekName() shows wrong week number (ISO-8601) in Official Support Articles

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

Environment

Resolution

Internal Investigation ID(s)