topic Invalid Autogenerage count:-1 in QlikView

Invalid Autogenerage count:-1

Sat, 18 Mar 2017 03:23:47 GMT

My data source is from oracle,the table name is THISFUNDASSET.

L_DATE

L_ID

2017-01-04

2016-08-05

2018-08-05

my script is:

LET varMinDate = NUM(PEEK('L_DATE',0,'THISFUNDASSET'));

LET varMaxDate = NUM(PEEK('L_DATE',-1,'THISFUNDASSET'));

TempCalendar:

Load

DATE($(varMinDate ) + ROWNO() -1) AS TempDate

AUTOGENERATE$(varMaxDate ) - $(varMinDate ) + 1;

MasterCalendar:

Load

DATE(TempDate) as Date,

WEEK(TempDate) as Week,

..........................

my problem is :

Invalid Autogenerate count:-1:TempCalendar:Load DATE($(varMinDate ) + ROWNO() -1) AS TempDate AUTOGENERATE -+1;

sunny_talwar — Sat, 18 Mar 2017 15:33:55 GMT

May be try like this

MinMax:

LOAD Min(L_DATE) as MinDate

Max(L_DATE) as MaxDate

Resident THISFUNDASSET;

LET varMinDate = Peek('MinDate');

LET varMaxDate = Peek('MaxDate');

TempCalendar:

Load

DATE($(varMinDate ) + ROWNO() -1) AS TempDate

AUTOGENERATE$(varMaxDate ) - $(varMinDate ) + 1;

MasterCalendar:

Load

DATE(TempDate) as Date,

WEEK(TempDate) as Week,

maxgro — Sat, 18 Mar 2017 15:37:46 GMT

AUTOGENERATE $(varMaxDate) - $(varMinDate) + 1;