topic Split time in QlikView

Split time

johanlind — Mon, 22 Nov 2010 08:24:43 GMT

I want to see the workload on a manufacturing group per day or maybe per week. I know when the manufacturing order starts, how many hours the order lasts and how many hours per day we work in that manufacturing group. Eg one order starts 2010-11-22 lasts for 20 hours and we work 8 hours per day in that manufacturing group, how do I do for the se the work load per day?

Split time

fernandotoledo — Tue, 23 Nov 2010 19:29:02 GMT

I would make a script solution breaking one order registry into several registries per day.

Something like a "While" statement that, in each step, loads the order, date+1 as date, duration-Time_per_day as duration where duration-Time_per_Day>=0

You should concatenate the results in the same table and use peek() to accumulate the result

It runs while a registry is read.

the result will be a table with how much hours were spent in each day. You can simply sum it in your charts.

Best regards

Fernando

Split time

johanlind — Wed, 24 Nov 2010 09:25:43 GMT

I'm not sure that I understand what you mean.
Do you have any example that shows how to do.

Split time

johanlind — Mon, 11 Jul 2011 09:45:18 GMT

Has anyone some new ideas?