WeekNumbers

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: WeekNumbers

Anonymous — Wed, 17 Aug 2016 09:10:24 GMT

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

Re: WeekNumbers

Gysbert_Wassenaar — Wed, 17 Aug 2016 09:12:12 GMT

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

topic WeekNumbers in QlikView

WeekNumbers

Re: WeekNumbers

Re: WeekNumbers