topic Re: Time Differrence in QlikView

Time Differrence

Wed, 25 Nov 2020 16:16:04 GMT

Good morning all,

I would like to calculate time difference between start_date_time and end_date_time the duration should be form 'hh:mm:ss' and thereafter I need calculate the total time per CallCentre, Desk, Team_Lead and Agent_Name in a pivot table. I have tried the following expression: =interval( end_date_time - start_date_time, 'hh:mm:ss'), but it bring back blanks. Not sure if I have to calculate it on the script level or expression !

Re: Time Differrence

Gysbert_Wassenaar — Mon, 05 Dec 2016 10:09:23 GMT

Make sure your timestamps are really timestamps and not strings. Use the Timestamp# function if necessary (in the script preferably) to turn strings into timestamp values.

Re: Time Differrence

Anonymous — Mon, 05 Dec 2016 10:23:33 GMT

You can refer Calculate Working Hour Interval Between Two Dates

Re: Time Differrence

nagarjuna_kotha — Mon, 05 Dec 2016 10:43:52 GMT

Hi Moses,

Try like below:

In the Expression:

Time(end_date_time ) - Time (start_date_time)

As @gwassenaar

said make sure that ur timestamp should be in timestanp.

Still if u have any issue then plz try to share some sample data along with output.

i Hope this helps you.

-Nagarjun

Re: Time Differrence

vcanale — Mon, 05 Dec 2016 10:51:11 GMT

Hi,

Try:
Interval((Interval(end_date_time, 'hh:mm:ss') - Interval(start_date_time, 'hh:mm:ss')), 'hh:mm:ss')

Re: Time Differrence

Mon, 05 Dec 2016 10:53:24 GMT

Thank you, it worked

Re: Time Differrence

Mon, 05 Dec 2016 10:54:40 GMT

should I use it as an expression or in script?

Re: Time Differrence

Mon, 05 Dec 2016 10:58:18 GMT

Thank you for the assistance

Re: Time Differrence

vcanale — Mon, 05 Dec 2016 11:16:02 GMT

Try

In the script:

timestamp(end_date_time,'MM/DD/YYYY hh:mm:ss') as end_date_time,

timestamp(start_date_time,'MM/DD/YYYY hh:mm:ss') as start_date_time

Expression:

Interval((Interval(end_date_time, 'hh:mm:ss') - Interval(start_date_time, 'hh:mm:ss')), 'hh:mm:ss')

Re: Time Differrence

Mon, 05 Dec 2016 11:29:31 GMT

Thank you, I have tried and it also worked.