topic Re: Fiscal calendar in QlikView

Fiscal calendar

Thu, 24 Apr 2014 05:00:15 GMT

Hello Experts,

How i make the Fiscal calendar which is start from april.

Thanks

Re: Fiscal calendar

tresB — Thu, 24 Apr 2014 05:01:38 GMT

Read this blog: http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

Re: Fiscal calendar

its_anandrjs — Thu, 24 Apr 2014 05:05:51 GMT

You can refer this documents

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

Re: Fiscal calendar

its_anandrjs — Thu, 24 Apr 2014 05:10:59 GMT

Create a fiscal calendar with this script

Set vFM = 4 ; // First month of fiscal year

Calendar:
Load Dual(fYear-1 &'/'& fYear, fYear) as FYear,          // Dual fiscal year
         Dual(Month, fMonth)                as FMonth,           // Dual fiscal month
          *;
Load Year + If(Month>=$(vFM), 1, 0) as fYear,           // Numeric fiscal year
         Mod(Month-$(vFM), 12)+1        as fMonth,          // Numeric fiscal month
          *;
Load Year(Date)                              as Year,           // Your standard master calendar
         Month(Date)                            as Month,

Re: Fiscal calendar

its_anandrjs — Thu, 24 Apr 2014 05:17:44 GMT

See the attached sample application for the Fiscal calendar

Let varMinDate = Num(Makedate(2006,1,1));

Let varMaxDate = Num(Makedate(Year(today()),Month(today()),Day(today())));

Datefield:

LOAD date($(varMinDate)+IterNo()-1) AS Datefield

AUTOGENERATE (1)

WHILE $(varMinDate)+IterNo()-1<= $(varMaxDate);

Set vFM = 4 ; // First month of fiscal year

Calendar:

Load Dual(fYear-1 &'/'& fYear, fYear) as FYear, // Dual fiscal year

Dual(Month, fMonth) as FMonth, // Dual fiscal month

Load Year + If(Month>=$(vFM), 1, 0) as fYear, // Numeric fiscal year

Mod(Month-$(vFM), 12)+1 as fMonth, // Numeric fiscal month

Load Year(Datefield) as Year, // Your standard master calendar

Month(Datefield) as Month,

Datefield

Resident Datefield;

DROP Table Datefield;

Regards

Re: Fiscal calendar

mdmukramali — Thu, 24 Apr 2014 05:26:12 GMT

Dear ,

find the attached sample apps.

Thanks,

Mukram.