topic Week and WeekName difference in Archived Groups

Week and WeekName difference

Marcio_Campestrini — Wed, 23 Jul 2025 14:48:52 GMT

Today, I've come across an unusual situation: the Week and WeekName functions do not calculate the same week for the same date.

According to the documentation the Week function returns in according to ISO8601, which for today (26/10/17) returns week 43.

The trick situation occurs when I use the WeekName function for the same date, which returns 2017/42.

kaushiknsolanki — Thu, 26 Oct 2017 17:28:36 GMT

Hi,

It seems to be a bug. Kindly report to Qlik Support for the same.

Regards,

Kaushik Solanki

Anders_Eriksson — Fri, 27 Oct 2017 07:13:29 GMT

Could it be that WeekName returns the week according to your OS settings?

el_aprendiz111 — Tue, 31 Oct 2017 15:55:03 GMT

Hi,

rbecher — Tue, 31 Oct 2017 16:10:35 GMT

Could it be your OS week starts on Sunday?

43 = WeekName(MakeDate(2017,10,26), 0, 0)

42 = WeekName(MakeDate(2017,10,26), 0, 6)

..and your Qlik app week starts on Monday:

Set FirstWeekDay=0;