topic Re: Number week 1 01/01/2017 in QlikView

Number week 1 01/01/2017

MauriceLudo — Mon, 20 Nov 2017 16:50:28 GMT

Hi,

I come back to you about week number, I would like to know that it is the best solution to always count on 01/01/2017 in the week number 1.

Here is a screenshot

Best regards

Maurice

Re: Number week 1 01/01/2017

YoussefBelloum — Mon, 20 Nov 2017 16:58:19 GMT

what do you want to do ?

Display week numbers instead of Dates ?

Re: Number week 1 01/01/2017

MauriceLudo — Mon, 20 Nov 2017 17:03:39 GMT

I would like to calculate the number of week of the year and I would like him to consider the 1st of January always in the week number 1

Re: Number week 1 01/01/2017

YoussefBelloum — Mon, 20 Nov 2017 17:05:26 GMT

can you share your app ? or sample data ?

Re: Number week 1 01/01/2017

MauriceLudo — Mon, 20 Nov 2017 17:21:54 GMT

here is the app

Re: Number week 1 01/01/2017

erjohnso — Mon, 20 Nov 2017 18:02:50 GMT

Create a table with week and week number using distinct, order by, autonumber and resident load:

WeekNumber:

Load Distinct

[WeekNumber Date de création Objet],

AutoNumber([WeekNumber Date de création Objet]) as WeekNum

RESIDENT Test_PilotageN2

Order By Y [WeekNumber Date de création Objet] ASC;

Re: Number week 1 01/01/2017

shraddha_g — Tue, 21 Nov 2017 05:55:41 GMT

Refer Redefining the Week Numbers

Try below code:

Let vCal_FD = 0; // First Day of the week {0=Mon, 1=Tue, ... , 6=Sun}

Let vCal_BW = 0; // Broken Weeks allowed {0=No, 1=Yes}

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

Load

if(TempDate < WeekRefDate and WeekNumber=0 and year(TempDate)<WeekYear,53,WeekNumber+1) as Actual_WeekNumber;

Load *,

Div( TempDate - WeekStart( WeekYearRefDate, 1, $(vCal_FD) ) + 7, 7 ) as WeekNumber,

Year( WeekYearRefDate ) as WeekYear;

Load *,

Date( YearStart( If( $(vCal_BW), TempDate, WeekRefDate )) + $(vCal_RD) - 1) as WeekYearRefDate ;

Load *,

Date( WeekStart( TempDate , 1, $(vCal_FD) ) - $(vCal_RD) ) as WeekRefDate ;

Re: Number week 1 01/01/2017

MauriceLudo — Tue, 21 Nov 2017 08:51:13 GMT

the WeekRefDate field corresponds to what exactly??

Re: Number week 1 01/01/2017

MauriceLudo — Tue, 21 Nov 2017 10:12:36 GMT

I do not understand why 01/01/2017 is week 48

Re: Number week 1 01/01/2017

shraddha_g — Tue, 21 Nov 2017 10:32:32 GMT

Try this in Calendar

Ceil((TempDate - WeekStart(YearStart(TempDate),0,0)+1)/7) as WeekNumber

Re: Number week 1 01/01/2017

MauriceLudo — Tue, 21 Nov 2017 11:25:12 GMT

I added in calendar but it does not work, I still have 01/01/2017 in week 52