topic Re: Reload time calculation in QlikView

Reload time calculation

Anonymous — Tue, 23 Dec 2014 08:53:49 GMT

Hi,

I calculate variables - one before script reload, the other one after reload.

let vStart = num(now());

let vEnd = num(now());

let vTime returns an error

let vTime = $(vStart) - $(vEnd);

What's incorrect? I'd like to get reload duration in time format.

Thanks

Re: Reload time calculation

manojkulkarni — Tue, 23 Dec 2014 09:02:50 GMT

It is working fine, not getting any error

Re: Reload time calculation

avinashelite — Tue, 23 Dec 2014 09:07:58 GMT

Hi Piotr,

Try like this:

let vstart=num(now());

let vend=num(ReloadTime());

let vtime=$(vstart)-$(vend);

Re: Reload time calculation

Anonymous — Tue, 23 Dec 2014 09:17:37 GMT

The same issue - can you check with my files?

Re: Reload time calculation

avinashelite — Tue, 23 Dec 2014 09:22:05 GMT

can you please post the app.

Re: Reload time calculation

francoiscave — Tue, 23 Dec 2014 09:24:21 GMT

Hi Piotr,

Try this:

let vTime = '$(vStart)'-'$(vEnd)';

Trace ## Total Time $(vTime);

François

Re: Reload time calculation

jagan — Tue, 23 Dec 2014 09:26:06 GMT

Hi,

Try like this

let vstart=now();

//Your load script goes here

let vend=now();

let vtime= Interval(vend - vstart, 's');

This will give you loadtime in seconds.

Regards,

jagan.

Re: Reload time calculation

Tue, 23 Dec 2014 09:41:42 GMT

HI,

let vStart = num(now());

let vEnd = num(now());

Let vTime=Interval(vStart-vEnd,'hh:mm:ss');

Re: Reload time calculation

Tue, 23 Dec 2014 10:02:06 GMT

try like this

let vStart = (now());

ABC:

LOAD A,

FROM

[2.csv] // 1 - ten z milionami

(txt, codepage is 1250, embedded labels, delimiter is ',', msq, no eof);

let vEnd = (now());

Let vTime=Interval(vStart-vEnd,'hh:mm:ss');

Trace ## Total Time $(vTime);