Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

best way to treat exceptions

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:

     

Machineweek day hoursSaturday hoursweek hoursmonth hours
Mach1100501000
Mach2100501000
Mach3100501000
Mach4105751500
Mach55025500
then check for exceptions
Machineweek day hoursSaturday hoursweek hoursmonth 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

2 Replies
josephinetedesc
Creator III
Creator III
Author

another question:

         

1/03/20152/03/20153/03/20154/03/20155/03/20156/03/20157/03/20158/03/2015
Mach109999900
Mach209999900
Mach309999900
Mach409999950
Mach504444400

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

josephinetedesc
Creator III
Creator III
Author

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