best way to treat exceptions

[josephinetedesc]

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

[josephinetedesc]

another question:

1/03/2015	2/03/2015	3/03/2015	4/03/2015	5/03/2015	6/03/2015	7/03/2015	8/03/2015
Mach1	0	9	9	9	9	9	0	0
Mach2	0	9	9	9	9	9	0	0
Mach3	0	9	9	9	9	9	0	0
Mach4	0	9	9	9	9	9	5	0
Mach5	0	4	4	4	4	4	0	0

How do I put this information easily into QlikView - it is a crosstable, the top line is a date

[josephinetedesc]

The Power of Qlik Script - Reshaping Data using Crosstable

What would I do without YouTube

The Power of Qlik Script - Reshaping Data using Crosstable - YouTube

Thank you Michael!

But:  when I use the crosstable (and I am in QlikView) I am unable to convert the dates to the date format.  I have tried to to use the Number overide - but to no avail!

Jo