Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a problem with my analisys. In our production we work more time in a day the same pieces on a machine.
In my DB the data are collected line by line for every working activity the machine perform.
I need to analyse the single working activity pieces by pieces but I don't know how to do it.
I give you an example
in this case the same Production Order (12345) go 2 time on the machine, one from 15.00 to 15.04 and one form 18.01 to 18.05.
How can I make the calculation for the ammount of time the PO was under the machine on a single working phase (1to5)?
How can I count the number of time we rework the same PO?
thanks a lot for your help!
See attached qvw.
View solution in original post
by counting working steps="5" each PO?
is Your data set order by Time, Working Step, PO?
First, you need a field with a unique value for a full working phase (1 to 5) ;
Then, you need an end period ("Time OFF").