Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bobbydave
Creator III
Creator III

Calendar to Fiscal

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;

1 Solution

Accepted Solutions
sasiparupudi1
Master III
Master III

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

1 Reply
sasiparupudi1
Master III
Master III

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