topic Re: calendar-week in QlikView

calendar-week

ttal7878 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In my model, I'm using calendar that displays, day, month, year and the number of the week.

I have a problem with the week dimension

The week between 31.12.2017 and 6.1.2018 is set as weeks53, Is it possible to change it to show week1?

I've included the model with the calendar I'm using,

I would appreciate any help

Re: calendar-week

YoussefBelloum — Thu, 18 Jan 2018 15:35:19 GMT

Hi,

try this:

if(Div( tempdate - WeekStart( WeekYearRefDate, 0, $(vCal_FD) ) + 7, 7 )=53,'1', Div( tempdate - WeekStart( WeekYearRefDate, 0, $(vCal_FD) ) + 7, 7 )) as WeekNumber,

Re: calendar-week

ttal7878 — Sun, 21 Jan 2018 10:45:28 GMT

Sorry for the late response,

It does not work.

When I the user selects Week - 1, the selected dates are 31-12-2017 till 13.1.2018

the result I want :

Week 53 - 31.12.2017

Week 1 - 01.01.2018 till 6.1.2018

Week 2 - 07.01.2018 till 13.01.2018

And so on.....

Re: calendar-week

Anil_Babu_Samineni — Sun, 21 Jan 2018 11:15:07 GMT

Can you try this Redefining the Week Numbers

Re: calendar-week

ttal7878 — Sun, 21 Jan 2018 13:03:28 GMT

According to Redefining the Week Numbers, I built the Week dimension

Re: calendar-week

Anil_Babu_Samineni — Sun, 21 Jan 2018 13:40:40 GMT

From there you can forecast the week based on Date field?

Re: calendar-week

sunny_talwar — Sun, 21 Jan 2018 17:55:22 GMT

I think you need to set vCal_RD = 4, instead of 7

Set vCal_RD = 4; // Reference day = This day in Jan defines week one {1..7}

Re: calendar-week

ttal7878 — Mon, 22 Jan 2018 08:45:16 GMT

Thank you