Week Number Based on Current Week

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello!

I hope someone can help me on this... My objective is to get the weeknumber based on current week until week 52.. IF More than week 52, it will be flagged as '52+'. However, based on my formula below, the week counter continues even when there is a gap on the MonDate. Pls. see below my desired output.

If([Monday for Date] < weekstart(today(1)),0,

If([Monday for Date] = weekstart(today(1)),1,

If([Monday for Date]<> weekstart(Peek([Monday for Date])),rangesum(peek([Week Number]),1),Peek([Week Number])))) as [Week Number]

This is my desired output :

1. slips the week number if there is a gap

2. Flagged week no to 52+ if weej number is more than 52.

Thank you in advance !

Re: Week Number Based on Current Week

Anonymous — Wed, 07 Jun 2017 06:10:59 GMT

Try this Requirement by creating ageing buckets on week number field.

topic Week Number Based on Current Week in QlikView

Week Number Based on Current Week

Re: Week Number Based on Current Week