topic Re: time interval calculation in QlikView

time interval calculation

Thu, 20 Mar 2014 15:08:42 GMT

I have a start time and end time. How do I get the duration or the interval between the start and end time.

suppose for an example,

starttime; 10.20 am

endtime: 2.20 pm

my desire result: 4.00.00

Nicole-Smith — Thu, 20 Mar 2014 15:12:52 GMT

This returns what you want:

=interval(time#('2.20 pm', 'h.mm TT')-time#('10.20 am', 'hh.mm TT'),'h.mm.ss')

So with field names:

=interval(time#(endtime, 'h.mm TT')-time#(starttime, 'hh.mm TT'),'h.mm.ss')

its_anandrjs — Thu, 20 Mar 2014 15:45:04 GMT

Hi,

Write some thing like

Interval( endtime - starttime , 'hh:mm TT' )

Hope this helps

Thanks & Regards

Anonymous — Thu, 20 Mar 2014 15:51:18 GMT

LOAD

id_number,

timestamp_from,

timestamp_to,

Interval(timestamp_from - Previous(timestamp_to) , 'hh:mm:ss') as Duration_time

FROM TableName

its_anandrjs — Thu, 20 Mar 2014 15:57:12 GMT

Hi,

Interval match only works in load script sop write a code like

Interval( endtime - starttime , 'hh:mm TT' ) as Time_Diff

Hope this helps

Thanks & Regards