topic Re: Script execution error in QlikView

Script execution error

markgraham123 — Wed, 05 Aug 2015 13:27:22 GMT

Hi all,

Can someone help me in identify the reason for script failure.

My script is as follows:

Temp:

Load

min([Ship Date]) as minDate,

max([Ship Date])+1 as maxDate

Resident Temp;

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;

TempCalendar:

LOAD

$(varMinDate) + Iterno()-1 As Num,

Date($(varMinDate) + IterNo() - 1) as TempDate

AutoGenerate 1 While $(varMinDate) + IterNo()-1 <= $(varMaxDate);

Error:

TempCalendar:

LOAD

+ Iterno()-1 As Num,

Date( + IterNo() - 1) as TempDate

AutoGenerate 1 While + IterNo()-1 <=

Error: Field not found - <<=>

General Script Error

Execution Failed

Execution finished.

Re: Script execution error

datanibbler — Wed, 05 Aug 2015 13:29:52 GMT

Hi Mark,

quite simple, you're missing an item following this mathematical operator.

HTH

Re: Script execution error

antoniotiman — Wed, 05 Aug 2015 13:37:14 GMT

Hi Mark,

Your variables varMinDate and varMaxDate are Null because You have

Temp:

Load

min([Ship Date]) as minDate,

max([Ship Date])+1 as maxDate

Resident Temp;

Re: Script execution error

markgraham123 — Wed, 05 Aug 2015 14:08:37 GMT

Hi Antonio,

Thanq verymuch.

Didn't notice that. It was Temp2 which is being loaded in the previous tab.

Thanq