Change to MakeWeekDate function in Qlik Cloud

[Sonja_Bauernfeind]

Several years back, we introduced the environment variables for calendars (FirstWeekDay, BrokenWeek, and ReferenceDay) and have since changed all functions with respect to these. However, MakeWeekDate was not updated accordingly, and we apologize for any inconvenience. Please review the documentation shared and linked below, and feel free to chat with us if you run into any further issues.

The function is now fixed and the documentation states the correct functionality. If you are using the MakeWeekDate function please consider the following:

Before the fix, MakeWeekDate would always follow the ISO standard for dates. This corresponds
to having the week localization settings in the load script like this:

SET FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;

If you have some other values for these variables in your load script, then the dates that are produced might have changed.

You should consider which values are the correct ones for you and change them accordingly.

Example 1: Almost all Europeans and many other countries use the ISO standard settings listed above.

Example 2: Other possible settings are for example American/Canadian week settings:

SET FirstWeekDay=6;
SET BrokenWeeks=1;
SET ReferenceDay=0;

Notice that every time you create a new app, these variables will be set automatically in the newly created load script.

If the automatic values do not correspond to the settings typically used in your country, you can change this behavior by updating your user profile settings and selecting your country/region in the list of regions.

Now, every time you create a new app the values should be set to the appropriate ones for your country.

Environment

Qlik Cloud

The change will be ported to client-managed installations in upcoming releases of QlikView and Qlik Sense Enterprise on Windows. We will update the article accordingly then.

Internal Investigation ID(s)

QB-17197