Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In my qlikview project of OEE, i'm trying to calculate stopping minutes per machine over dates and shifts.
I divide a day into 3 parts, 00-08, 08-16, 16-24 shifts. So, one shift is 8 hours.
I'm trying to get net working minutes. there may be such data that stopping is 1180 minutes. So, it is bigger than a shift which is 480 minutes.
In the data, it is on 1 row but I should divide it into shifts.
For example assume that stopping time is 12.02.2018 05:00 and stoppage is 1180 minutes.
I show it this way:
Machine | Date | Shift | Working Time(min) | Stoppage (min) | Net Working Time |
AAA | 12.02.2018 | 00-08 | 480 | 1180 | -700 |
Customer desires to show the same data in this way:
Machine | Date | Shift | Working Time(min) | Stoppage (min) | Net Working Time |
AAA | 12.02.2018 | 00-08 | 480 | 180 | 300 |
AAA | 12.02.2018 | 08-16 | 480 | 480 | 0 |
AAA | 12.02.2018 | 16-24 | 480 | 480 | 0 |
AAA | 13.02.2018 | 00-08 | 480 | 40 | 440 |
Could you please suggest me a solution how to achieve it?
Thanks,
Perhaps this discussion helps: Task/Ticket Duration
Or this one: Calculate hours between two Date/Time strings
Or Expression with Working Days and working Hours
Thanks a lot. I have implemented below solution according to my requirements.