Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Strange calendar behavior

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.

grab pivot.jpg

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 ?

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Strange calendar behavior

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.

3 Replies

Re: Strange calendar behavior

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


talk is cheap, supply exceeds demand
Not applicable

Re: Strange calendar behavior

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.

Not applicable

Re: Strange calendar behavior

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.

Community Browser