topic Why does this simple script generate an error?!?!? in QlikView

Why does this simple script generate an error?!?!?

Anonymous — Wed, 01 Jun 2011 14:21:27 GMT

Hi all

I am trying to generate a table with load times. For the life of me i can't understand why this generates an error. If i change the Let's to Set's it works, but will not give me the proper start time.

Any ideas??

LET vStartTime = Now();

....running script for about 2 minutes....

LET vEndTime = Now();

LoadTime:

LOAD 'Stage1' AS Stage, $(vStartTime) AS StartTime, $(vEndTime) AS EndTime AUTOGENERATE(1);

PS I'm running QlikView 9

Cheers

Robbie

Why does this simple script generate an error?!?!?

pat_agen — Wed, 01 Jun 2011 14:29:10 GMT

hi,

just enclose your variables in simple quotes in th eload statement:

LoadTime:

LOAD 'Stage1' AS Stage,

'$(vStartTime)' AS StartTime,

'$(vEndTime)' AS EndTime AUTOGENERATE(1);

that should do it.

Why does this simple script generate an error?!?!?

patrickanderson — Wed, 01 Jun 2011 14:31:39 GMT

How about this?

X.ReloadTime:

REPLACE LOAD

now() as ReloadTime

AUTOGENERATE (1);

///Script...........................

// At end of Script Put below.

LET StartTime = num(peek('ReloadTime',-1,'X.ReloadTime'));

X.LoadTime:

REPLACE LOAD

interval(now() - $(StartTime),'h:m:ss') as LoadTime

AUTOGENERATE (1);

Why does this simple script generate an error?!?!?

Wed, 01 Jun 2011 14:38:11 GMT

if you create a line in your load script and type this.

LET vStartTime = '=Now()';

That should work...

Why does this simple script generate an error?!?!?

Anonymous — Thu, 02 Jun 2011 10:31:11 GMT

Cheers guys!