topic Re: Elapsed Time Calculation in QlikView

Elapsed Time Calculation

Mon, 12 Jan 2015 11:01:42 GMT

Hello !

I have 2 timestamp fields like this :

I need to calculate the elapsed time, in Seconds, amongst those TimeStamp pairs.

How do I do that ?

Thanks in advance for your support !

jzimolong — Mon, 12 Jan 2015 11:05:37 GMT

Try checking this out:

its_anandrjs — Mon, 12 Jan 2015 11:07:02 GMT

Hi,

Try this if fields are in pure time stamp fields.

Interval( [End Time] - [Start Time],'s' )

Interval( [End Time] - [Start Time],'ss' )

Regards

Anand

MarcoWedel — Mon, 12 Jan 2015 11:59:31 GMT

also possible:

(EndTimeStamp-StartTimeStamp)*86400

meaning: difference of the timestamps in days * seconds per day

hope this helps

regards

Marco

Fri, 16 Jan 2015 11:18:48 GMT

Thanks 4 your help !

I have solved the issue.

Here are some lines showing the concept on a standalone script (QVW) of mine that I use as a 'laboratory' :

LET INTERVALO=INTERVAL(MAKEDATE(2015,01,15)-MAKEDATE(2015,01,01),'D hh:mm');

TRACE $(INTERVALO);

Thanks again !