Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm currently in the process of adding some calendars to my data load, however experiencing some problems. There are 2 calendars for 2 unconnected data sources within the load. My calendar script is as follows:
//Sales Calendar Script
SalesCalendar:
Load
TempDate AS SalesDate,
week(TempDate) As SalesWeek,
Year(TempDate) As SalesYear,
Month(TempDate) As SalesMonth,
Day(TempDate) As SalesDay,
'Q' & ceil(month(TempDate) / 3) AS SalesQuarter,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as SalesWeekYear,
WeekDay(TempDate) as SalesWeekDay,
If(Num([TempDate]) >= Num([TempDate]), 0, 0) As Sales_Current_YTD,
If(Num([TempDate]) >= Num([TempDate]), -1, 0) As Sales_LY_YTD,
//
If( InWeekToDate (TempDate, $(CurrentDate),0),1) as SalesWTD, // All Dates This Week To Date This Year
If( InWeekToDate (TempDate, $(CurrentDate), -1),1) as SalesLWTD, // All Dates Previous Week To Date
If( InMonthToDate (TempDate, $(CurrentDate),0),1) as Sales_MTD_TY, // All Dates This Month To Date This Year
If( InMonthToDate (TempDate, $(CurrentDate),-12),1) as Sales_MTD_LY, // All Dates This Month To Date Last Year
If( InMonthToDate (TempDate, $(CurrentDate), -1),1) as Sales_LM_MTD, // All Dates Previous Month To Date
//
inyeartodate(TempDate, $(varToday), 0, 3) * -1 AS SalesFinancialCurYTDFlag,
inyeartodate(TempDate, $(varToday), -1, 3) * -1 AS SalesFinancialLastYTDFlag
;
//=== Generate a temp table of dates ===
LOAD
date(mindate + IterNo()) AS TempDate
,maxdate // Used in InYearToDate() above, but not kept
WHILE mindate + IterNo() <= maxdate;
//=== Get min/max dates from Field ===/
LOAD
min(FieldValue([Date], recno()))-1 as mindate,
max(FieldValue([Date], recno())) as maxdate
AUTOGENERATE FieldValueCount([Date]);
//Supplier Deliveries Calendar Script
SupDelRR:
Load
TempDate AS SupDelRRDate,
week(TempDate) As SupDelRRWeek,
Year(TempDate) As SupDelRRYear,
Month(TempDate) As SupDelRRMonth,
Day(TempDate) As SupDelRRDay,
'Q' & ceil(month(TempDate) / 3) AS SupDelRRQuarter,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as SupDelRRWeekYear,
WeekDay(TempDate) as SupDelRRWeekDay,
If(Num([TempDate]) >= Num([TempDate]), 0, 0) As SupDelRR_Current_YTD,
If(Num([TempDate]) >= Num([TempDate]), -1, 0) As SupDelRR_LY_YTD,
//
If( InWeekToDate (TempDate, $(CurrentDate),0),1) as SupDelRRWTD, // All Dates This Week To Date This Year
If( InWeekToDate (TempDate, $(CurrentDate), -1),1) as SupDelRRLWTD, // All Dates Previous Week To Date
If( InMonthToDate (TempDate, $(CurrentDate),0),1) as SupDelRR_MTD_TY, // All Dates This Month To Date This Year
If( InMonthToDate (TempDate, $(CurrentDate),-12),1) as SupDelRR_MTD_LY, // All Dates This Month To Date Last Year
If( InMonthToDate (TempDate, $(CurrentDate), -1),1) as SupDelRR_LM_MTD, // All Dates Previous Month To Date
//
inyeartodate(TempDate, $(varToday), 0, 3) * -1 AS SupDelRRFinancialCurYTDFlag,
inyeartodate(TempDate, $(varToday), -1, 3) * -1 AS SupDelRRFinancialLastYTDFlag
;
//=== Generate a temp table of dates ===
LOAD
date(mindate + IterNo()) AS TempDate
,maxdate // Used in InYearToDate() above, but not kept
WHILE mindate + IterNo() <= maxdate;
//=== Get min/max dates from Field ===/
LOAD
min(FieldValue([receiptreturndate], recno()))-1 as mindate,
max(FieldValue([receiptreturndate], recno())) as maxdate
AUTOGENERATE FieldValueCount([receiptreturndate]);
/////////////////////////////////////////////////////////////////////
And the full error message is below:
The following error occurred:
You're posting in a QlikView forum.
For more targeted answers, you may want to move this Question to a Qlik Sense forum by following the steps outlined here: QlikCommunity Tip: How to move your discussion thread
Hi,
For me also the same Error, Can you please provide the solution for this error ..
Thanks and Regards....