topic Re: Error in creating Calendar in QlikView

Error in creating Calendar

Anonymous — Mon, 21 Sep 2015 06:50:24 GMT

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

Re: Error in creating Calendar

PrashantSangle — Mon, 21 Sep 2015 07:00:58 GMT

Hi,

What is your script after AUTOGENERATE statement

Error is after AUTOGENERATE statement

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

Regards

Re: Error in creating Calendar

Anonymous — Mon, 21 Sep 2015 07:03:45 GMT

Script attached

Re: Error in creating Calendar

PrashantSangle — Mon, 21 Sep 2015 07:14:33 GMT

Hi,

in text object check variable varMaxDate Value.

also try below modification.

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

Regards

Re: Error in creating Calendar

Anonymous — Mon, 21 Sep 2015 09:26:00 GMT

Hi,

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

\Regards

Re: Error in creating Calendar

Anonymous — Mon, 21 Sep 2015 09:26:21 GMT

p.s. I tried the modification with no luck

Re: Error in creating Calendar

PrashantSangle — Mon, 21 Sep 2015 09:47:02 GMT

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

Re: Error in creating Calendar

Anonymous — Mon, 21 Sep 2015 09:59:04 GMT

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/>

Re: Error in creating Calendar

simenkg — Mon, 21 Sep 2015 10:01:14 GMT

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

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

Re: Error in creating Calendar

ecolomer — Mon, 21 Sep 2015 10:04:48 GMT

Try this:

Load

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

RowNo() as OrdNo

autogenerate 2190;

Re: Error in creating Calendar

simenkg — Mon, 21 Sep 2015 10:05:28 GMT

Your problem is that varMaxDate is empty.

It probably has something to do with the where statement in your Dates_TMP.

Perhaps if you change the Where clause to :

where num(%DateKey) >2

ORDER BY %DateKey asc;

the number 2 comes from the fact that dates in QlikView is the number of days since 31.12.1899, so 1.1.1900 will be date number 2.

Re: Error in creating Calendar

Anonymous — Mon, 21 Sep 2015 10:06:52 GMT

Thank-you but it has been suggested and it did not fix the issue ☹

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>

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

Proud supporter of:

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

Re: Error in creating Calendar

sasiparupudi1 — Mon, 21 Sep 2015 10:08:00 GMT

your varMaxDate is null

check if the following populate the value properly into the varable

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

hth

Sasi

Re: Error in creating Calendar

simenkg — Mon, 21 Sep 2015 10:16:18 GMT

Change from:

Dates_TMP:

Load

if(IsNull(%DateKey),makedate(1900,1,1),%DateKey) as %DateKey

RESIDENT Facts

where if(IsNull(%DateKey),makedate(1900,1,1),%DateKey) <>makedate(1900,1,1)

ORDER BY %DateKey;

to:

Dates_TMP:

Load

max(%DateKey) as maxDateTemp

RESIDENT Facts;

and

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

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

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

To:

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

Let varMaxDate = Num(Peek(maxDateTemp,0,'Dates_TMP'));

Re: Error in creating Calendar

Mon, 21 Sep 2015 10:22:29 GMT

Hi,

I think your variable storing END DATE is not in num format.

Please convert the enddate variable into num and try.

Re: Error in creating Calendar

Anonymous — Mon, 21 Sep 2015 10:24:52 GMT

Where should I place this? At the very start?

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>

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

Proud supporter of:

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

Re: Error in creating Calendar

Anonymous — Mon, 21 Sep 2015 10:30:52 GMT

How do I do this please?

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>

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

Proud supporter of:

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

Re: Error in creating Calendar

tripatirao — Mon, 21 Sep 2015 10:35:53 GMT

Go through this link you will get more information

https://community.qlik.com/docs/DOC-8843

Re: Error in creating Calendar

Anonymous — Mon, 21 Sep 2015 10:56:40 GMT

Thank you

Sent from my iPhone