topic Timstamp Intervals in QlikView

Timstamp Intervals

ilanbaruch — Tue, 07 Nov 2017 16:02:41 GMT

hi all,

trying to calculate duration in minutes between 2 Timstamps

create Timstamp in script as below:

Timestamp(StartDate&' '&StartTime,'YYYYMMDD hh:mm') as StartStamp,

Timestamp(EndDate&' '&EndTime,'YYYYMMDD hh:mm') as EndStamp,

calculating interval in both script and layout as below

Interval(EndStamp-StartStamp,'hh:mm')

and looks ok but,

when there is a day deference result comes bad... i.e :

end stamp = 20171105 00:01

start stamp = 20171104 23:56

endstamp - startstamp retrieves : -23:54 from script calculation

216:06 in layout calculation

where the result is 00:06.....

would appreciate your help,

advanced thanks

Re: Timstamp Intervals

rbailey007 — Tue, 07 Nov 2017 16:08:59 GMT

Use the below instead of interval

(EndStamp-StartStamp)*1440

Re: Timstamp Intervals

el_aprendiz111 — Tue, 07 Nov 2017 17:09:51 GMT

Hi,

=Interval(
Time( Frac( Timestamp#( '20171104 23:56', 'YYYYMMDD hh:mm')), 'hh:mm')
-
Time( Frac( Timestamp#( '20171105 00:01', 'YYYYMMDD hh:mm')), 'hh:mm')
,'hh mm')