Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Fiscal Year Calendar

I have this script as fiscal year calendar:

FiscalYear:

Set vFM = 4;

Load Dual(Month, (Mod(Month-$(vFM), 12)+1))             as FMonth,           // Dual fiscal month

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

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

          *

Resident Calendar

order by Year,Month asc;

and i use this expression for my calendar to get the first date of year in normal calendar (calendar year): =YEARSTART(MAX(DATEPERIOD)

when i use it in fiscal year, it works for months that is in the same year (from april to dec i get ' April 1st' from that expression)

but when i select jan-mar i get 'January 1st' as the first date. how could i get also April 1st as the first date of fiscal year?

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Mike,

maybe

YearStart(Max(DATEPERIOD),0,vFM)

Regards,

Antonio

View solution in original post

2 Replies
antoniotiman
Master III
Master III

Hi Mike,

maybe

YearStart(Max(DATEPERIOD),0,vFM)

Regards,

Antonio

Anonymous
Not applicable
Author

that's great. thanks so much