Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Reload time calculation

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

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

8 Replies
manojkulkarni
Partner - Specialist II
Partner - Specialist II

It is working fine, not getting any error

avinashelite

Hi Piotr,

Try like this:

let vstart=num(now());

let vend=num(ReloadTime());

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

Anonymous
Not applicable
Author

The same issue - can you check with my files?

avinashelite

can you please post the app.

francoiscave
Partner - Creator III
Partner - Creator III

Hi Piotr,

Try this:

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

Trace ## Total Time $(vTime);

François

jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

HI,

let vStart = num(now());

let vEnd = num(now());

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

Not applicable
Author

try like this

let vStart = (now());

ABC:

LOAD A,

    B,

    C

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);