Hi
Assume I have 5 machines (Mach1, Mach2, Mach3, Mach4, Mach5) All (except March4) work daily for 10 hours. March4 works only 5 hours a day. Mach3 works on a Saturday for 5 hours. The other exception is when there is a holiday or something .
I have a formula inolving a percentage ie actual hours worked over total hours expected over a day and then over a week and then over a month,
Obviously one solution would be to have a huge table showing dealer day and hours and then import this into QlikView.
However there must be a better way, I want to use something like - ordinary day per machine = 10 or 5 hours. Ordinary week = 250 hours , Ordinary month = 250 * working days.
I would like QkikView to use the "normal" hours unless there is an exception. How would I do the exception? Would it be best to subtract hours at the daily level on each machine?.
so somthing like this:
| Machine | week day hours | Saturday hours | week hours | month hours |
| Mach1 | 10 | 0 | 50 | 1000 |
| Mach2 | 10 | 0 | 50 | 1000 |
| Mach3 | 10 | 0 | 50 | 1000 |
| Mach4 | 10 | 5 | 75 | 1500 |
| Mach5 | 5 | 0 | 25 | 500 |
| then check for exceptions |
| Machine | week day hours | Saturday hours | week hours | month hours |
| Mach1 | -10 | -10 | -10 |
| Mach2 | -10 | -10 | -10 |
| Mach3 | -10 | -10 | -10 |
| Mach4 | -10 | -10 | -10 |
| Mach5 | -10 | -10 | -10 |
Hope I have explained this well.
Jo
