Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating actual takt time

Hi,

I'm trying to calculate the actual takt time per station.


Example: 1 Machine glues two parts together. Once it's done it safes a timestamp. This is done with every part.

However the machine produces different parts, based on settings. It doesn't know if there's a shiftbreak, a holiday etc.

Therefor what I'm trying to do is to calculate takt time " Timestamp - Previous(Timestamp) AS Taktzeit, "

And now I'd like to calculate the avg Taktzeit where Takzeit < 2*(Stdev(Taktzeit)).
This would eliminate all shift breaks + larger machine crashes etc. while still showing minor erros if timings go up or down.

I can't wrap my head around the most elegant solution for this though.

Any ideas?

Thank you!

4 Replies
Clever_Anjos
Employee
Employee

If possible share some your data with us

QlikCommunity Tip: How to get answers to your post?

prieper
Master II
Master II

Try with the formula:

AVG(IF(Taktzeit < 2/24, Taktzeit))

Guess that Taktzeit will be part of a day, therefore 2 hours are 2/24 days.

Peter

Not applicable
Author

You're right, I'm sorry, here's some example data:

Load

Ident,

Timestamp,

$Measure,

Type,

Timestamp - PREVIOUS(Timestamp) AS Taktzeit,

IdentTimestamp$MeasureType
93098242008,9048311
93098342008,9051461
93098442008,9053461
93098542008,9054431
93098642008,9057461
93098742008,9058491
93098842008,90951841
93098942008,90982093
93099042008,90992153
93099142008,91011903
93099242008,91032094
93099342008,91052065
93099442008,92171935
93099542008,92192025
93099642008,92211904
93099742008,92232064
93099842008,92251964
93099942008,92272154
93100042008,92291932
93100142008,92312122
93100242008,92332122
93100342008,92352122

I haven't included Taktzeit since it ignores the Type atm.

=Time(avg(Taktzeit)) = Value including gabs between non production days + breaks. Atm. @ ~25 seconds.

my thought was to use a set analysis like this: "=time(avg({<$={'>0'}>+<$={'<00:00:35'}>}Taktzeit))"this doesn't give me the expected result though. It still shows the common avg which is way to high due to breaks and non production days

So all my solutions currently ignore the type thingy. However thinking about it it might be better to not calculate within the script but in the application itself to be able analyze including all types as well as single types by themselves as well.

Any ideas?

swuehl
MVP
MVP

I think your last expression shows incorrect syntax in the set expression, try something like this instead:

=Interval(Avg({<Taktzeit= {"<=$(=Num('00:00:35','.',','))"} >}Taktzeit))