Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hi All,
I have a data given below screenshot.
| ID | StartDateUTC | EndDateUTC | IPAddress | ReasonCode |
| 95634D78-64CE-43B3-B430-0926A9DEDEA5 | 07-06-2021 15:27 | 07-06-2021 20:28 | 10.22.33.70 | 112 |
The requirement is have to take time difference between StartDate and EndDate field. The overall time diff is 5:0:10.
I have to split the data like this:
| StartTime | EndTime | Downtime in Mins |
| 00:00 | 01:00 | 0 |
| 01:00 | 02:00 | 0 |
| 02:00 | 03:00 | 0 |
| 03:00 | 04:00 | 0 |
| 04:00 | 05:00 | 0 |
| 05:00 | 06:00 | 0 |
| 06:00 | 07:00 | 0 |
| 07:00 | 08:00 | 0 |
| 08:00 | 09:00 | 0 |
| 09:00 | 10:00 | 0 |
| 10:00 | 11:00 | 0 |
| 11:00 | 12:00 | 0 |
| 12:00 | 13:00 | 0 |
| 13:00 | 14:00 | 0 |
| 14:00 | 15:00 | 0 |
| 15:00 | 16:00 | 33 |
| 16:00 | 17:00 | 60 |
| 17:00 | 18:00 | 60 |
| 18:00 | 19:00 | 60 |
| 19:00 | 20:00 | 60 |
| 20:00 | 21:00 | 32 |
| 21:00 | 22:00 | 0 |
| 22:00 | 23:00 | 0 |
| 23:00 | 00:00 | 0 |
Thanks in advance. @MayilVahanan @sunny_talwar @marcus_sommer
Regards,
Dinesh.
