topic Re: Wrong week number in calendar in QlikView

Wrong week number in calendar

fabienmd — Thu, 05 Sep 2013 06:45:45 GMT

Hi,

I have an issue with the calendar object. It doesn't have the right week number and I don't know how to explain that to the users.

For example, If you go to the 26/06/2013, it's in week 26 (if you do Weekname('26/26/2013') Qlikview also says 2013/26) but in the left column of the calendar, it has the number 25.

Is there any way to make it right ?

Regards,

Fabien

Re: Wrong week number in calendar

jfkinspari — Thu, 05 Sep 2013 06:53:38 GMT

I would suspect, that there is no way to change this

Re: Wrong week number in calendar

hic — Fri, 06 Sep 2013 07:02:56 GMT

QlikView uses ISO 8601 to get week numbers, and there is no way to change that.

However, you can make a smart script and define your own week numbers. See script at bottom of

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/23/ancient-gods

HIC

Re: Wrong week number in calendar

fabienmd — Fri, 06 Sep 2013 07:47:00 GMT

But my problem is that the calendar object in qlikview doesn't use ISO 8601.

As I said, Qlikview is right when I do "Weekname('26/26/2013')", it gives me week 26. But the calendar object is showing week 25 (see my picture in the first post).

Re: Wrong week number in calendar

hic — Fri, 06 Sep 2013 08:14:00 GMT

That's new to me... Seems like a bug. I'll report it.

HIC

Re: Wrong week number in calendar

Mon, 25 Aug 2014 10:14:13 GMT

Hi, i believe i have the same problem, in 2014 using QlikView 8.5

Week number seems to be starting from the day 1 in the Year (The day 1 in 2014 is Wednesday) so the first week is from 01.01.2014 till 07.01.2014 and so on

Re: Wrong week number in calendar

Tue, 02 Feb 2016 12:48:39 GMT

Hi HIC,

do you have some news about this bug?

I'm using QlikView 11.20 SR6 and i have the same error on the week of calendar object.

Mario