Discussion Board for collaboration on QlikView Scripting.
Can someone help me in identify the reason for script failure.
My script is as follows:
min([Ship Date]) as minDate,
max([Ship Date])+1 as maxDate
Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
Let varCurrentYear = year(Peek('maxDate'));
Let varCurrentMonth = MonthName(Peek('maxDate'));
Let varCurrentQuarter = QuarterName(Peek('maxDate'));
DROP Table Temp;
$(varMinDate) + Iterno()-1 As Num,
Date($(varMinDate) + IterNo() - 1) as TempDate
AutoGenerate 1 While $(varMinDate) + IterNo()-1 <= $(varMaxDate);
+ Iterno()-1 As Num,
Date( + IterNo() - 1) as TempDate
AutoGenerate 1 While + IterNo()-1 <=
Error: Field not found - <<=>
General Script Error
Your variables varMinDate and varMaxDate are Null because You have
View solution in original post
quite simple, you're missing an item following this mathematical operator.
Didn't notice that. It was Temp2 which is being loaded in the previous tab.