Hi All,
I am new to Qlikview.
I am trying to achieve this in Qlikview. Can any suggest me how to do it.
My Data Set:
| Part | Event | Time |
| 12345 | StartTime | 4/26/18 10:30 AM |
| 12345 | EndTime | 4/26/18 12:30 PM |
| 11111 | StartTime | 4/25/18 10:00 AM |
| 11111 | EndTime | 4/25/18 11:00 AM |
| 22222 | StartTime | 4/24/18 11:20 AM |
| 22222 | EndTime | 4/24/18 12:20 PM |
I would like to calculate the difference between start time and end time for each part and average it out. I want this happen in one expression.
In this case the result is (2 hours for first part+1 hour for second part + 1 hour for third part). so the average is 4/3
I have used Only({<Event={'EndTime'}>}Time)-Only({<Event={'StartTime'}>}Time) to get the difference. I am not sure how to calculate the average though.
Can someone help me with this?
Thanks,
