Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

"Week 53" -problem

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 Apicture Apicture Bpicture B

 

or then like this (picture C) & LOAD -settings like this:(picture D):


picture Cpicture Cpicture Dpicture 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.

Labels (2)
1 Reply
Highlighted
Master II
Master II