Fiscal Calendar

[#1]

Hi ,

i am new to qlikview. I have a sales data , i need to prepare a fiscal calendar.

The company operates on a fiscal calendar that starts Jul 1 and ends Jun 30. The fiscal periods correlate to calendar months. The company has provided three years of fiscal data that spans four calendar years. For trending selections i have to use fiscal Calendar.

The table below describes how calendar periods relate to fiscal years and periods.

Can you please suggest the code.. Any help will be highly appreciated

Calendar Period	Fiscal Year	Fiscal Period
7/1/2006	2007	1
8/1/2006	2007	2
9/1/2006	2007	3
10/1/2006	2007	4
11/1/2006	2007	5
12/1/2006	2007	6
1/1/2007	2007	7
2/1/2007	2007	8
3/1/2007	2007	9
4/1/2007	2007	10
5/1/2007	2007	11
6/1/2007	2007	12
7/1/2007	2008	1
8/1/2007	2008	2
9/1/2007	2008	3
Please note that this table is not complete

[spsrk_84]

Hi ,

I have attached one sample file .gothrough that i hope it will help you..

Regards,

Ajay

[#3]

Hi Ajay,

Thanks a lot. its working fine. but i have to map this fiscal calendar to my Master calendar. Any suggestions/code will be highly appreciated.

Thanks in Advance,

Phani

[spsrk_84]

Hi.

I need some understanding about your calendar how it looks like So can u atach some sample data of the Master Calendar...

try this option also like try to concatenate the code i sent early with th e Master Calendar Script which you with you.

Regards,

Ajay

[#5]

Hi Ajay,

Can i have your personnel mail id , so that i can send my application(sample).

Regards,

Phani

[#6]

Hi ,

Please go through the attached file

Phani

[spsrk_84]

Hi , I added one more tab in your script So replace your Calendar tab script with the modified one..

Any issues let me know

send your Personal mail ID also i will reply to that

Regards,

Ajay

[#8]

HI Ajay,

Thanks a ton. its working fine. pdaram0@gmail.com is my mail id. can you pls shoot a test mail to my id.

Regards,

Daram Phani

[johnw]

,year(yearstart("Calendar Period",1,7)) as "Fiscal Year"
,num(month(monthstart("Calendar Period",6))) as "Fiscal Period"