topic Re: Calculation for a single working phase on the same piece in QlikView

Calculation for a single working phase on the same piece

Mon, 11 Feb 2013 13:34:06 GMT

Hy All,

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

Production Order	Sequence Number	Working Step	Time ON
12345	1001	1	15.00 11/02/2013
12345	1002	2	15.01 11/02/2013
12345	1003	3	15.02 11/02/2013
12345	1004	4	15.03 11/02/2013
12345	1005	5	15.04 11/02/2013
12345	1500	1	18.01 11/02/2013
12345	1501	2	18.02 11/02/2013
12345	1502	3	18.03 11/02/2013
12345	1503	4	18.04 11/02/2013
12345	1504	5	18.05 11/02/2013

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!

Mon, 11 Feb 2013 13:53:21 GMT

How can I count the number of time we rework the same PO?

by counting working steps="5" each PO?

How can I make the calculation for the ammount of time the PO was under the machine on a single working phase (1to5)?

is Your data set order by Time, Working Step, PO?

Gysbert_Wassenaar — Mon, 11 Feb 2013 13:57:43 GMT

See attached qvw.

vivientexier — Mon, 11 Feb 2013 14:02:30 GMT

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").