Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculation for a single working phase on the same piece

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
Header 5
123451001115.00 11/02/2013
123451002215.01 11/02/2013
123451003315.02 11/02/2013
123451004415.03 11/02/2013
123451005515.04 11/02/2013
123451500118.01 11/02/2013
123451501218.02 11/02/2013
123451502318.03 11/02/2013
123451503418.04 11/02/2013
123451504518.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!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Not applicable
Author

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

See attached qvw.


talk is cheap, supply exceeds demand
vivientexier
Partner - Creator II
Partner - Creator II

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