topic Re: Strange calendar behavior in QlikView

Strange calendar behavior

Fri, 04 Jan 2013 10:22:41 GMT

Hi.

Happy new year to all of you and thank you for the community

So, at new year, new strange issue.

I give you below the screenshot of one of my application that give me a strange thing concerning the calendar.

As you can see, I have the first row which is the year of documents on which I do the accounting in the pivot (just a count function), second row is the week, and third is the delivery date.

So basically, at the end of year 2012, is logical to have week 52 and 1 appearing as we have deliveries on both weeks.

But it is not logical there because if we refer to the year, we should normally have 2013 for the week 1 The two fields are in the load script : [Entete Année] = Year([Entete Date]) and [Entete semaine] = week([Entete Date]) where [Enete Date] is the date of documents stored in the DB.

Any idea ?

Re: Strange calendar behavior

Gysbert_Wassenaar — Fri, 04 Jan 2013 10:55:55 GMT

You should probably use the WeekYear function instead of the Year function for the Entete Année field.

Re: Strange calendar behavior

Fri, 04 Jan 2013 13:11:05 GMT

Thank you Gysbert. in the time you were answering, I had a look at it, and it seems that I should comme from that mistake. I'll confirm later as soon as I have verified.

Re: Strange calendar behavior

Fri, 04 Jan 2013 13:53:36 GMT

So, finally, the weekyear function gives the good information if I use a calculated dimension for the year instead of the one loaded in the script. If I use month as dimension, we have a week 1 within december. It's weird but logical.