Create fiscal calendar

[#1]

Hello,

Does anyone has a sample of a fiscal calendar that starts with february?

[Siva_Sankar]

Check with it       use set vYear as your wish          =if(MakeWeekDate(vYear, Week(Date#('1/4/'&vYear,'D/M/YYYY')),0)

[#3]

hi,

Generate a normal ccalendar date, and then put the following code

year(yearname(DATE,0,2))  AS [Fiscal Year],

if (month(DATE)<=1,month(DATE)+(12-1), month(DATE)-1) AS [Fiscal Month Num]

[jagannalla]

LET vDateMin = Num(MakeDate(2009,2,1)); 

LET vDateMax = Floor(MonthEnd(Today())); 

LET vDateToday = Num(Today()); 

TempCalendar: 

LOAD

$(vDateMin) + RowNo() - 1 AS DateNumber, 

Date($(vDateMin) + RowNo() - 1) AS TempDate 

AUTOGENERATE 1 

WHILE $(vDateMin)+IterNo()-1<= $(vDateMax); 

[#5]

How about Fiscal Quarter, I created like this 

dual('Q' & if(month(Date)<4,4,floor(mont(Date)/3)) ,quarterstart(Date)) as FinancialQuarter;

ended up in creating 4 Quarters values for each year , which cannot be used in list box for selection criteria .

any idea on this

[rwunderlich]

You may want to try the Qlikview Components calendar. A fiscal calendar starting Feb is created with this statement:

CALL Qvc.CalendarFromField('OrderDate', 'Fiscal Calendar', 'Fiscal ', '2');

http://qlikviewcomponents.org

-Rob

[Anonymous]

Pratibha Kumar wrote:

hi,

Generate a normal ccalendar date, and then put the following code

year(yearname(DATE,0,2))  AS [Fiscal Year],

if (month(DATE)<=1,month(DATE)+(12-1), month(DATE)-1) AS [Fiscal Month Num]

Was looking for a simple version of this without changing the world.  This worked perfectly for me !!