Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Week of Financial Year

Hello Guys,

     I stuck in calculating the week of the financial year....

     Actually, The financial year starts from April to March.

     So the first week of April should be the starting week of the year.

     How can I get this result...? Help me in this.

     Thanks in advance.

RB

1 Reply
swuehl
MVP
MVP

Hi Rajan,

Haven't found an easy QlikView funtion way, maybe I have missed something.

You could always use

=num(([Date]+275-(MakeDate(Year([Date]+275-mod([Date]-2,7)+3), 1, (mod([Date]-2,7)+1) )-10))/7-0.5,'###0')

to calculate the week of financial year (starting April). Week numbering is in accordance / analogy to ISO-8601.

Regards,

Stefan

P.S: If you want a different start of financial year, replace both occurences of 275 with number of days from financial year start till end of calendar year (i.e. April 1st  to December 31 = 275)

Hope this helps,

Stefan