Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having an rather annoying problem with the weekly view in reports, where "week 53 2019" and "week 1 2020" isn't quite showing up as expected... Either it looks like this: (picture A), and the LOAD -settings looks like this: (picture B), picture A
picture B
or then like this (picture C) & LOAD -settings like this:(picture D):
picture C
picture D
In the first version (A & B) the week 52 covers the days 23.12.2019 - 29.12.2019, and week 2 covers 06.01.2020 - 12.01.2020. So week 1 (the real week 1 according to my calendar) is totally missing...
If again we look at the situation for pictures C & D, then the week 53 covers the days 30.12.2019 - 31.12.2019 and the week 1 covers 01.01.2020 - 05.01.2020.
So here the weeks 53 and 1 (30.12.2019 - 05.01.2020) are actually, if combined, the real calendar week 1, but why are they split into two weeks in the reporting view... ?
I tried all possible combinations (I think) of the "FirstWeekDay", "BrokenWeeks" and "ReferenceDay", but without any success.
Maybe this blog post will help:
https://community.qlik.com/t5/Qlik-Design-Blog/Redefining-the-Week-Numbers/ba-p/1467199