Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II