Error in creating Calendar

[Anonymous]

Hi,

I keep getting the following error when QlikView runs the Master Calendar script :-

I've checked the variables exist.  I've checked "DateNumber,", "TempDate," and "DateRowID" are not referenced anywhere else.

Any idea's on what area's I can check?

Script line error:

TempCalendar:

LOAD

39630 + rowno() - 1 AS DateNumber,

date (39630 + rowno() - 1) AS TempDate,

rowno() as DateRowID

AUTOGENERATE

  - 39630 + 1

Cheers,

Laura

[PrashantSangle · Accepted solution]

Hi,

What is your script after AUTOGENERATE statement

Error is after AUTOGENERATE statement

before - 39630 was any variable , because something missing over there.

Regards

[Anonymous]

Script attached

[PrashantSangle]

Hi,

in text object check variable varMaxDate Value.

also try below modification.

Let varMaxDate = Num(Peek('%DateKey',-1,'Dates_TMP'));

Regards

[Anonymous]

Hi,

when you say check the varMaxDate Value,  do you mean to check Settings\Variable Overview?

\Regards

[Anonymous]

p.s. I tried the modification with no luck

[PrashantSangle]

No,

Create Text Object then write

=varMaxDate

also try from your script , comment below line

Let varMinDate = Num(MakeDate(2008,7,1));

Let varMaxDate = Num(MakeDate(2016,7,1));

and comment below lines

//Let varMinDate = Num(Peek('%DateKey',0,'Dates_TMP'));

//Let varMinDate = Num(MakeDate(2008,7,1));

//Let varMaxDate = Num(Peek('%DateKey',0-1,'Dates_TMP'));

then reran again and check that it is still giving you error or not .

Regards

[Anonymous]

Sorry but I don’t understand the terminology. How do I “Create Text Object”. Like this?

Create Text Object =varMaxDate

?

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

Proud supporter of:

<http://acci.headsup.org.au/>

[simenkg]

Change the line:
Let varMaxDate = Num(Peek('%DateKey',0-1,'Dates_TMP'));

To

Let varMaxDate = Num(Peek('%DateKey',-1,'Dates_TMP'));

[ecolomer]

Try this:

Load

  date(num(41275) + RowNo()    as Date,

  RowNo()                                 as OrdNo

autogenerate 2190;