# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for
Did you mean:
Not applicable

## Fiscal calendar

Hello Experts,

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

Thanks

1 Solution

Accepted Solutions
MVP

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:

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

*;

Month(Datefield)             as Month,

Datefield

Resident Datefield;

DROP Table Datefield;

Regards

5 Replies
MVP
MVP
MVP

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
*;
Month(Date)                            as Month,

MVP

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:

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

*;

Month(Datefield)             as Month,

Datefield

Resident Datefield;

DROP Table Datefield;

Regards

Specialist III

Dear ,

find the attached sample apps.

Thanks,

Mukram.

Community Browser