topic Re: Time Difference between timestamps in QlikView

Time Difference between timestamps

Wed, 29 Jan 2014 12:19:11 GMT

Hi,

Does anyone knows how to get the difference in Time between two TimeStamp vars?

Ex:

LET vSTART = NOW();

... Process

LET vEND = NOW();

LET vTime = ?

TRACE >>> Executed in: $(vTime);

Thanks in advance

Wed, 29 Jan 2014 12:42:40 GMT

Does Anyone Know it?

I am stuck on it

Thanks

maxgro — Wed, 29 Jan 2014 12:44:28 GMT

LET vSTART = NOW();

LOAD

rand()

AutoGenerate 10000000;

LET vEND = NOW();

LET vTime = interval(vEND - vSTART, 'hh:mm:ss');

TRACE >>> Executed in: $(vTime);

LOg:

AUTOGENERATE(10000000) 10.000.000 lines fetched

>>> Executed in: 00:00:10

Wed, 29 Jan 2014 12:47:23 GMT

Thank you so much Massimo!

Works perfectly!

MK_QSL — Wed, 29 Jan 2014 12:47:40 GMT

At the start of the script i.e. after system variable...

TYPE

let vLastLoadStart = now();

and

at the end of the all script...

TYPE

let vLastLoadEnd = now();

Now you can get Load Time Duration difference by

date(vLastLoadEnd - vLastLoadStart, 'hh:mm:ss')