Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
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!

Tags (2)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

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

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Highlighted
Not applicable

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

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?

Highlighted
MVP & Luminary
MVP & Luminary

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

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Partner
Partner

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

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