Is there A known bug on the WEEK() function?

[#1]

In a Text Object expression:

= 'Week(MakeDate(2000,1))=' & Week(MakeDate(2000,1)) & Chr(10)

& 'Week(MakeDate(2001,1))=' & Week(MakeDate(2001,1)) & Chr(10)

& 'Week(MakeDate(2002,1))=' & Week(MakeDate(2002,1)) & Chr(10)

& 'Week(MakeDate(2003,1))=' & Week(MakeDate(2003,1)) & Chr(10)

& 'Week(MakeDate(2004,1))=' & Week(MakeDate(2004,1)) & Chr(10)

& 'Week(MakeDate(2005,1))=' & Week(MakeDate(2005,1)) & Chr(10)

& 'Week(MakeDate(2006,1))=' & Week(MakeDate(2006,1)) & Chr(10)

& 'Week(MakeDate(2007,1))=' & Week(MakeDate(2007,1)) & Chr(10)

& 'Week(MakeDate(2008,1))=' & Week(MakeDate(2008,1)) & Chr(10)

& 'Week(MakeDate(2009,1))=' & Week(MakeDate(2009,1)) & Chr(10)

& 'Week(MakeDate(2010,1))=' & Week(MakeDate(2010,1)) & Chr(10)

& 'Week(MakeDate(2011,1))=' & Week(MakeDate(2011,1)) & Chr(10)

& 'Week(MakeDate(2012,1))=' & Week(MakeDate(2012,1)) & Chr(10)

& 'Week(MakeDate(2013,1))=' & Week(MakeDate(2013,1)) & Chr(10)

& 'Week(MakeDate(2014,1))=' & Week(MakeDate(2014,1)) & Chr(10)

& 'Week(MakeDate(2015,1))=' & Week(MakeDate(2015,1)) & Chr(10)

& 'Week(MakeDate(2016,1))=' & Week(MakeDate(2016,1)) & Chr(10)

& 'Week(MakeDate(2017,1))=' & Week(MakeDate(2017,1)) & Chr(10)

& 'Week(MakeDate(2018,1))=' & Week(MakeDate(2018,1)) & Chr(10)

& 'Week(MakeDate(2019,1))=' & Week(MakeDate(2019,1)) & Chr(10)

Results:

[swuehl]

It's not a bug. QlikView uses ISO week numbering (widely used e.g. in Europe).

[Gysbert_Wassenaar · Accepted solution]

Qlikview follows the ISO 8601 date standard:

If 1 January is on a Monday, Tuesday, Wednesday or Thursday, it is in week 01. If 1 January is on a Friday, Saturday or Sunday, it is in week 52 or 53 of the previous year (there is no week 00). 28 December is always in the last week of its year.

So, not a bug.

[#4]

Thanks!

[swuehl]

See also

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/27/week-numbers