MASTER CALENDAR SCRIPT LINE ERROR

Fri, 25 Jul 2014 13:10:52 GMT

I am getting Script Line Error. . Please see the attached File for ERROR Print SCreen. It was working fine uptil now and all of a sudden lsat night gave an error

TEMP:

LOAD
num(min(ACCTGDTE)) AS MinDate,
num(max(ACCTGDTE)) AS MaxDate
RESIDENT
AcctSumm
;

LET vMinDate =

peek('MinDate', 0, 'TEMP');

LET

vMaxDate =

peek('MaxDate', 0, 'TEMP');

LET

vToday =

num(

today());

LET

vYesterday =

num(

today()-1);

DROP

TABLE TEMP;

//Returns all rows of data form the first row, '0', to the last, '-1'

//**************************************************Temporary Calendar*************************************************************
TempCalendar:

LOAD

$(vMinDate) +

RowNo() - 1

Num,

date(

$(vMinDate) +

RowNo() - 1)

TempDate

AUTOGENERATE

$(vMaxDate) -

$(vMinDate) + 1;

//Returns number of rows dependent on the number of day between Min-Max

//****************************************************MasterCalendar***************************************************************

MasterCalendar:

//Commonly used date funcitions

LOAD

// Date(TempDate) AS Date, //Links to Data

num(

TempDate)

%DateLink,

num(

TempDate)

Date_Num,

// Week(TempDate) AS Week,

Year(

TempDate)

Year,

Month(

TempDate)

Month,

Num(

Month(

TempDate),'0')

Period,

// Day(TempDate) AS Day,
// Weekday(TempDate) AS WeekDay,
'Q' &

ceil(

month(

TempDate) / 3)

Quarter,

Date(

MonthStart(

TempDate),'MMM-YYYY')

MonthYear,
'Q' &

ceil(

month(

TempDate) / 3)&'-'&

Year(

TempDate)

QuarterYear

RESIDENT
TempCalendar

ORDER

TempDate

ASC
;

DROP

TABLE TempCalendar;

Re: MASTER CALENDAR SCRIPT LINE ERROR

Anonymous — Fri, 25 Jul 2014 18:09:23 GMT

Hi Ray,

It seems that both variables $(vMinDate) and $(vMaxDate) are empty. My suggestion is to check the following section of the code. Evaluate what are you getting in the load statement (MinDate and MaxDate) and then check the variable creation.

TEMP:

LOAD
num(min(ACCTGDTE)) AS MinDate,
num(max(ACCTGDTE)) AS MaxDate
RESIDENT
AcctSumm
;

LET vMinDate =

peek('MinDate', 0, 'TEMP');

LET

vMaxDate =

peek('MaxDate', 0, 'TEMP');

LET

vToday =

num(

today());

LET

vYesterday =

num(

today()-1);

DROP

TABLE TEMP;

Regards,

Re: MASTER CALENDAR SCRIPT LINE ERROR

Anonymous — Fri, 25 Jul 2014 18:34:36 GMT

Is your field ACCTGDTE a proper QlikView date ?

Or is it a text representation of a date ?

topic Re: MASTER CALENDAR SCRIPT LINE ERROR in QlikView

MASTER CALENDAR SCRIPT LINE ERROR

Re: MASTER CALENDAR SCRIPT LINE ERROR

Re: MASTER CALENDAR SCRIPT LINE ERROR