WeekNumbers

[#1]

Hey guys,

Please I need some help.

Customer          Date          Vol1        Vol2

ChatterTech      01-03-16    15,550    16,350

ChatterTech      02-03-16      20,632    21,369

-----------------------------------------------------------------

ChatterTech      30-04-16      18,632    19,369

Based on these sample table I have these customer's information from the 1st of March to the 30 of April 2016. So I created a calendar based on the field Date and I wanted to analyse the data based on Week number. For the two months I expect to see the week numbers from 9,10,11,12,13,14,15, and 16. But instead I am seeing week numbers from 10 through to 18 without week 9 even. So please any help on how to get these done. My desired results is if I click on March, I should see week 9,10,11 and 12. And if its April, I should see week 13,14,15 and 16. Since logically January has week 1 to 4 and February week 5 to 8.

Thanks

[Anonymous]

what is your Default date Format? DD-MM-YY?

maybe you should use so the date is recognized correct

=week(date#('30-04-16','DD-MM-YY'))

[Gysbert_Wassenaar]

What function do you use to calculate the week? Qlikview uses the ISO 8601 standard. See this blog post: https://community.qlik.com/blogs/qlikviewdesignblog/2014/01/27/week-numbers