topic Re: Amend Week Start and Year Start in QlikView

Amend Week Start and Year Start

cpiocpio — Wed, 19 Feb 2014 21:38:45 GMT

I am trying to sort out a Master Calendar, but have a need for amending the week start day to SUNDAY and the Year Start to June.

In fact the Year Start are as follows, of course Week Number has to start on the June date as well, commencing on Sundays.

dd/mm/yyyy

03/06/2012

02/06/2013

01/06/2014

I have tried using AddMonths(date,6,0) to the week function but it does not return for example the correct week numbers

Mike

Re: Amend Week Start and Year Start

Wed, 19 Feb 2014 21:50:11 GMT

Possible to upload a sample file

Thanks

Re: Re: Amend Week Start and Year Start

cpiocpio — Thu, 20 Feb 2014 09:06:34 GMT

As requested here ia smaple, all the details are within the QVW

Re: Re: Amend Week Start and Year Start

cpiocpio — Thu, 20 Feb 2014 09:24:31 GMT

Think there is a typo in my file, here is updated inline, i had a FInYear value incorrect for 04/06/2014

* INLINE [
    CalDueDate, i_lifts, FinYear, Country
    01/01/2011, 2,2010/11, UK
    02/01/2011, 2,2010/11,GMBH
    06/01/2012, 2,2011/12,UK
    08/01/2012, 2,2011/12,UK
    02/06/2013, 5,2011/12,UK
    03/06/2012, 2,2012/13,UK
    05/02/2014, 3,2013/14,UK
    10/02/2014, 7,2013/14,UK
    12/02/2014, 2,2013/14,GMBH
    13/02/2014, 1,2013/14,GMBH
    13/02/2014, 1,2013/14,GMBH
    01/06/2014, 4,2013/14,UK
    04/06/2014, 2,2014/15,GMBH
];

Re: Amend Week Start and Year Start

Gysbert_Wassenaar — Thu, 20 Feb 2014 09:27:18 GMT

See this blog post: Redefining the Week Start

And this blog post: Redefining the Week Numbers

Re: Amend Week Start and Year Start

cpiocpio — Thu, 20 Feb 2014 09:47:07 GMT

I attach another version, hipefully have got all the date right this time, not that it would made any difference to the question, but now the numbers add up correctly

Re: Amend Week Start and Year Start

cpiocpio — Thu, 20 Feb 2014 13:01:35 GMT

Thanks for pointers

this blog post Redefining the Week Start

Did assit me to amend Week Start and WeekEdn to Sunday and Saturday

But this blog post:

Redefining the Week Numbers

did not get me where I want to be, I think because I also need to ask another question : How to change YEAR START and therefore change the Week Numbering

Basically here are the year start and week numbering starts on these dates: (as per orgonal post)

Commencing on Sundays, the year starts need to be.

dd/mm/yyyy

03/06/2012

02/06/2013

01/06/2014

Re: Amend Week Start and Year Start

MK_QSL — Thu, 20 Feb 2014 13:20:27 GMT

Please check enclosed file..

Use fMonth as Finance Month (i.e. Start Month of Year)