topic Re: Calculate Difference in Time in QlikView

Calculate Difference in Time

QFanatic — Wed, 17 Feb 2021 10:35:55 GMT

Hi guys

Please find attached.

I need to calculate the difference in Time in script. Field name is 'Event_Duration'. I've tried doing it with interval but it returns nothing.

Where am I going wrong?

Thank you!

haskia — Wed, 17 Feb 2021 21:58:40 GMT

Make sure to convert your date and time fields from strings into actual dates or times with Date#(), Time#() or Timestamp#().

Then you can easily use calculations like Interval() and they will work like a charm.. 🙂

Example for Duration:

=Interval(Timestamp#(Event_End_Dt_Tm, 'YYYYMMDD hh:mm:ss') - Timestamp#(Event_Strt_Dt_Tm, 'YYYYMMDD hh:mm:ss'), 'hh:mm:ss')

QFanatic — Thu, 18 Feb 2021 07:05:38 GMT

Thank you so much