
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
July to June Fiscal Year, how to design the Week Number?
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be look at how to generate fiscal year calendar:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be share a script where you are having trouble and we might be able help you with it?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
