topic Re: Wrong result from 'week' function in QlikView

Wrong result from 'week' function

david_ze — Tue, 04 Oct 2011 22:00:31 GMT

Hi all,
I'm using the 'week' function to retrive the week number of a date.
When the field's data is '01/01/2011' the result is '52'...!

I'll appreciate if someone can reply me with the reson for this, and also the proposed solution.

Thanks in advance,
David

Wrong result from 'week' function

swuehl — Tue, 04 Oct 2011 22:28:33 GMT

Qlikview User IMHO the ISO definition for week numbering which is e.g. different from the one used in US I believe.

Week 1 is the week containig the first würdest oft the year.

Hope this helps,

Stefan

P.S. If you need different numbering, search the forum, I believe there are samples for Most Standard Systems.

Re: Wrong result from 'week' function

Tue, 04 Oct 2011 22:41:36 GMT

Hi 52 is the last week of 2010.

1/1/2011 falls down in that week.

Try to catch this week during load andchange with 1.

C u,

Stefano

Wrong result from 'week' function

swuehl — Tue, 04 Oct 2011 22:47:35 GMT

Damn Mobile..

I meant the week with the first thursday oft a year is week number 1.

Regards

Stefan

Re: Wrong result from 'week' function

mazacini — Fri, 30 Mar 2012 08:53:17 GMT

swuehl wrote:
Damn Mobile..
I meant the week with the first thursday oft a year is week number 1.
Regards
Stefan

With this infomration , I think I was able to sort this problem which I faced myself.

So I simply changed the script from

Week(Date) as Week

Week(Date+2) as Week

Seems to work!

Wrong result from 'week' function

swuehl — Fri, 30 Mar 2012 10:12:57 GMT

I don't think that this will work in general.

Maybe you want to check out the compilation of different week numbering standards that John has posted some time ago:

http://community.qlik.com/message/72204

Regards,

Stefan

Re: Wrong result from 'week' function

Fri, 30 Mar 2012 10:29:11 GMT

Hi,

David,

this will solve your problem

num(subfield(LunarWeekName ('1/1/2011'),'/' ,2))

Please check correct if you got ur answer

Re: Wrong result from 'week' function

sivarajs — Fri, 30 Mar 2012 11:06:22 GMT

Try this

IF ((DayNumberOfYear(date)) < 7 and week(date) > 2 , 1 , week(date#( date, 'DD/MM/YYYY')))

Sivaraj S

Re: Wrong result from 'week' function

Fri, 30 Mar 2012 18:24:48 GMT

I had the same issue and did not like how it was displaying so I used this formula. Not the most elegant or exact, but I works for me:

if(week(CalendarDate)>50 and month(CalendarDate)<10,1,week(CalendarDate)) as 'Calendar Week',

I just had issues with the sorting, not so much with the 52.

Re: Wrong result from 'week' function

Tue, 08 Oct 2013 09:48:53 GMT

Definitely not elegant but it does work to avoid jumps on bar chart from one year to another.

Thanks !