Master Calender with Fiscal year

Ama1 — Tue, 22 Jun 2021 07:05:07 GMT

Hi,

I want to create master calender with fiscal year that starts from Mar 1st .

can any one please share the script

Re: Master Calender with Fiscal year

sasikanth — Tue, 22 Jun 2021 08:08:18 GMT

Try

below script

Let vFM_NO=3;

Load
TempDate AS DATE_KEY,
Year(TempDate) As Year,
Month(TempDate) As Month,
Day (TempDate) as Day,

Year(TempDate) + If(Month(TempDate)>=$(vFM_NO), 1, 0) as FinYear,
Mod(Month(TempDate)-$(vFM_NO), 12)+1 as FinMonth,
'Q'&ceil((Mod(Month(TempDate)-$(vFM_NO), 12)+1)/3) as FY_Qrter,

Dual((Year(TempDate) + If(Month(TempDate)>=$(vFM_NO), 1, 0))-1 &'-'& (Year(TempDate) + If(Month(TempDate)>=$(vFM_NO), 1, 0)),
(Year(TempDate) + If(Month(TempDate)>=$(vFM_NO), 1, 0))) as FY_Year,

dual(Month(TempDate),Mod(Month(TempDate)-$(vFM_NO), 12)+1) as FY_Month

resident Master_Calendar;

topic Re: Master Calender with Fiscal year in Qlik Learning Discussions

Master Calender with Fiscal year

Re: Master Calender with Fiscal year