July to June Fiscal Year, how to design the Week Number?

[#1]

My Fiscal Year starts at July and ends at June, so could you please suggest a way to design the week number and also the best BI practices to handle the week 53.

[sunny_talwar]

May be look at how to generate fiscal year calendar:

Fiscal and Standard Calendar generation

[#3]

Hi Sunny,

Thanks a lot for your suggestion, but I have a problem in creating the Fiscal Week Numbers, Month and Quarters are already fixed, i am highly facing an issue with this week calculation.

If possible, please help me with that.

Kind Regards,

Balaji R

[sunny_talwar]

May be share a script where you are having trouble and we might be able help you with it?

[#5]

Hi Sunny,

Attached my entire file.

All I want is 1-Jul-2012 should start with Week-1 and break down weeks (Week 53 and Week 1) can be as it is, no need to make any changes to that.

Fiscal Year Cycle:

01-July-2012 to 30-June-2013

Kind Regards,

Balaji R

[#6]

Hello All,

I achieved my results in Excel, but not able to replicate it in qlikview formula.

The formula in excel is below, Cell A2 contains the date "01-07-2012"

=INT((A2-DATE(YEAR(A2+184)-1,7,1)-WEEKDAY(A2))/7)+2

Can you guys please help me to convert this formula.

Kind Regards,

Balaji R