I have a perfectly working Fiscal Calendar built application attached.
I then had another application where I took one tab QVE which is a calendar year built application and put this QVE tab into the Fiscal Calendar and need to change it so it becomes a fiscal calendar.
I can get the QVE tab working as a calendar month but am trying to get it to work with the fiscal calendar.
I'm guessing it's got to do with my calendar.
I cant deviate from the T_Calendar.qvd as this is a company calendar.
I know the problem lies with the where exist clause
Any ideas.
MasterCalendar:
LOAD //Date,
If(Year(Date#(Date, 'DD/MM/YYYY')) >= 2014,
Date) as Date,
//%Calendar,
If(Year(Date#(%Calendar, 'DD/MM/YYYY')) >= 2014,
%Calendar) as %Calendar,
[Trans Date],
Formatted_Date,
Year,
Month,
Week,
Day,
Quarter,
DayName,
WeekName,
YearWeek,
YearMonth,
YearMonthName,
Calendar_Period,
CurrYrFlag,
PrevYrFlag,
YTDFlag,
Prev_YTDFlag,
Curr_Quarter_Flag,
Previous_Quarter_Flag,
QTDFlag,
Prev_QTDFlag,
Curr_Month_Flag,
Prev_Month_Flag,
LastFullMonth_TY_Flag,
LastFullMonth_LY_Flag,
MTDFlag,
Prev_MTDFlag,
WTDFlag,
Prev_WTDFlag,
Last3Months_TY_Flag,
Last3Months_LY_Flag,
MAT,
[MAT-1],
Fiscal_Year,
Fiscal_Period,
FiscalYearPeriod as %FiscalYearPeriod,
Fiscal_Month,
Fiscal_Year_Month,
Fiscal_YearQuarter,
Fiscal_Quarter,
num(date#(Fiscal_Year_Month,'YYYY-MM')) as Fiscal_Year_Month_Num,
Fiscal_Month_Start_Date,
Fiscal_Month_End_Date,
Fiscal_Week,
Fiscal_Year_Week,
Fiscal_WeekNoInMonth,
Fiscal_MonthNoWeeks,
Year_Month_Formatted,
Fiscal_Year_Month_Formatted
FROM
[$(vQVDPath)\T_Calendar.qvd](qvd)
//Where Exists (%FiscalYearPeriod, %FiscalYearPeriod);
Where Exists (%Calendar, %Calendar);
Map_FiscalMonthStart:
Mapping Load %Calendar, Fiscal_Month_Start_Date
Resident MasterCalendar;
