topic Re: Weekname(date) shows wrong week in 2021 in QlikView

Weekname(date) shows wrong week in 2021

jakobjosef — Sat, 16 Nov 2024 17:30:30 GMT

Hi,

unfortunately a function in qlikview-script is not working correctly:

weekname(date) shows the wrong week - for the 01.01.2021 it should be week "2020-53", but qlikview shows 2021-01; the weeks afterwards are wrong as well...

Is there a possibility that this error gets fixed?

Greetings

Jakob

Re: Weekname(date) shows wrong week in 2021

Taoufiq_Zarra — Mon, 08 Feb 2021 12:56:19 GMT

@jakobjosef for example

=weekname('01/01/2021',0) gives :

Re: Weekname(date) shows wrong week in 2021

yassinemhadhbi — Mon, 08 Feb 2021 14:07:19 GMT

Good morning

In QlikView variables ( Main tab : first tab in the script ) make sure that the variable BrokenWeeks is set to 0

Re: Weekname(date) shows wrong week in 2021

jakobjosef — Tue, 09 Feb 2021 06:43:02 GMT

Dear Yassinemhadbi,

this was exactly what I was looking for. Thank you so much for your hint, i would have never tried it this way.
Thanks a lot, also to your hint Taofiq!
Jakob