Calculating Avg(Time Difference)

[sarath_babu]

Hi All,

Am new to QlikSense . I have used interval function to calculate time difference . But the result is not matching with the database.

Interval(start_time-date,'hh:mm:ss') As DiffTime

Both date ares in yyyy-mm-dd hh:mm:ss format

Can you please suggest any other way to solve this

[Anil_Babu_Samineni]

Will you able to provide few rows of data?

[sarath_babu]

This is how data is in the database

StartTime, Date,Average

2018-09-10 07:02:30	2018-09-10 07:01:22	00:01:08
2018-09-26 23:08:33	2018-09-26 23:07:25	00:01:08
2018-08-30 07:40:43	2018-08-30 07:39:36	00:01:07
2018-09-04 02:48:40	2018-09-04 02:47:34	00:01:06
2018-10-04 07:50:15	2018-10-04 07:49:09	00:01:06
2018-08-07 12:16:38	2018-08-07 12:15:32	00:01:06
2018-08-08 02:42:03	2018-08-08 02:40:58	00:01:05
2018-10-30 23:13:29	2018-10-30 23:12:26	00:01:03
2018-10-09 22:35:09	2018-10-09 22:34:08	00:01:01
2018-10-19 02:27:17	2018-10-19 02:26:20	00:00:57

[Anil_Babu_Samineni]

PFA, I don't see any problem using your condition in script and UI

[sarath_babu]

Hi Thanks for the reply..

actually i need to calculate the first occurrence of date.

Interval(startTime-min(date),'hh:mm:ss') as Diff

then Avg(Diff) as ResponseTime.

But in the front end i got the values like '23:56:55' which should be like '00:00:40'. 

That is the reason i have asked for alternate function other than interval.