topic Re: Create fiscal calendar in QlikView

Create fiscal calendar

Thu, 21 Jun 2012 10:11:28 GMT

Hello,

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

Re: Create fiscal calendar

Siva_Sankar — Thu, 21 Jun 2012 10:56:31 GMT

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

Re: Create fiscal calendar

Thu, 21 Jun 2012 11:10:44 GMT

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]

Re: Create fiscal calendar

jagannalla — Thu, 21 Jun 2012 11:33:17 GMT

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);

Re: Create fiscal calendar

Tue, 26 Jun 2012 02:46:35 GMT

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

Re: Create fiscal calendar

rwunderlich — Tue, 26 Jun 2012 05:04:56 GMT

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

Re: Create fiscal calendar

Anonymous — Wed, 22 Apr 2015 13:11:19 GMT

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 !!