topic Fiscal Calendar in QlikView

Fiscal Calendar

Fri, 15 Oct 2010 08:41:11 GMT

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

Fiscal Calendar

spsrk_84 — Fri, 15 Oct 2010 10:43:42 GMT

Hi ,

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

Regards,

Ajay

Fiscal Calendar

Fri, 15 Oct 2010 10:54:24 GMT

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

Fiscal Calendar

spsrk_84 — Fri, 15 Oct 2010 11:10:01 GMT

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

Fiscal Calendar

Fri, 15 Oct 2010 11:23:20 GMT

Hi Ajay,

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

Regards,

Phani

Fiscal Calendar

Fri, 15 Oct 2010 11:33:14 GMT

Hi ,

Please go through the attached file

Phani

Fiscal Calendar

spsrk_84 — Fri, 15 Oct 2010 11:56:22 GMT

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

Fiscal Calendar

Fri, 15 Oct 2010 12:39:59 GMT

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

Fiscal Calendar

johnw — Fri, 15 Oct 2010 19:02:56 GMT

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