Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register 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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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