Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
fabienmd
Partner - Creator
Partner - Creator

Wrong week number in calendar

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.

Inbox - Microsoft Outlook.jpg

Is there any way to make it right ?

Regards,

Fabien

6 Replies
jfkinspari
Partner - Specialist
Partner - Specialist

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

hic
Former Employee
Former Employee

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

fabienmd
Partner - Creator
Partner - Creator
Author

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).

hic
Former Employee
Former Employee

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

HIC

Not applicable

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

Not applicable

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.

BR

Mario