Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 |
PFA, I don't see any problem using your condition in script and UI
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.