Finding WeekNo -Feb as Year Starting and Sunday as weekstart

[suryaa30]

Hi

I have to find week no from given Invoice date.

Feb is the year start

Sunday is the week start

Div((Invoice_Date-YearStart(Invoice_Date,0,2)-WeekDay(YearStart(Invoice_Date))+3),7)+1

Any help is appreciated. Thanks

[Thiago_Justen_]

Surya,

I'm not sure if I'm missing anything but: Why don't you use Week() function?

[suryaa30]

Week takes Jan as reference.

I want my weekno to start from Feb of every year.

[Thiago_Justen_]

So, please try this out:

Week(YOUR_DATE_FIELD,6,0,31)

[suryaa30]

I am somewhere close to the requirement with this, but still looking for other options

Week(YOUR_DATE_FIELD,6,0,31)-1

Thanks Much

[brunobertels]

Hi

See if this post can help

https://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

[Thiago_Justen_]

Hey Surya,

Any news about it? If this thread is solved, please let us know by marking the correct answer.

Cheers