Morning
I once again would like to get some assistance with a problem I am having in Qlikview (April 2020 sr2). I need to calculate the service level, which is the difference between a start datetime field and and an end datetime field. The results must be shown in days as once field and the number of hours, minutes and seconds in the other field. When presenting the results as a table I get the following:
| EventsID | Count | Days | HH:MM:SS |
| 353023 | 1 | 0 | 0:06:17 |
| 353058 | 1 | 0 | 1:06:04 |
| 353073 | 1 | 0 | 23:06:16 |
| 353078 | 1 | 0 | 23:26:09 |
| 353089 | 1 | 1 | 18:39:02 |
| 353128 | 1 | 0 | 16:07:09 |
| 353129 | 1 | 0 | 16:12:48 |
| 353130 | 1 | 2 | 17:59:42 |
| 353167 | 1 | 0 | 0:01:20 |
| 353169 | 1 | 0 | 0:08:32 |
| 353175 | 1 | 0 | 0:44:11 |
| 353183 | 1 | 0 | 0:41:24 |
| 353185 | 1 | 0 | 0:14:26 |
| 353196 | 1 | 0 | 0:32:52 |
| 353232 | 1 | 13 | 23:07:45 |
| 353236 | 1 | 13 | 23:38:31 |
| 353238 | 1 | 13 | 23:48:18 |
| Total | 17 | 2 | 22:27:06 |
When manually checking the results I am comfortable that the results are correct.
When representing the same data as a graph the time axis shows a range from 04:00:00:00 PM to 01:00:00 AM. When hovering the mouse over the datapoint, the correct time is shown, but that value does not match with what the corresponding value on the axis shows.
In my calculation I have added a time format, and set my time format in the number properties.
