Discussion Board for collaboration related to QlikView App Development.
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
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;
Preparing examples for Upload - Reduction and Data Scrambling
HI please reduce your file size using the techniques suggested in the above doc
View solution in original post