Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mitjap
Contributor III
Contributor III
‎2021-09-22 06:01 AM

Mes system - cycle analysis

Hello.

i would like to build app for production control. in future i hope to integrete this with sql so i get real time control over machines

this is my problem

Table one: i get this times form Mes cycle data

part numberfeature_timestampvirsifra
300 50022.09.2021 11:26:34163
300 50022.09.2021 11:18:13163
300 50022.09.2021 11:08:13163
300 50022.09.2021 10:59:53163
300 50022.09.2021 10:51:33163
300 20022.09.2021 10:43:12163
300 20022.09.2021 10:34:52163
300 20022.09.2021 10:27:22163

 

data from ERP. gives time when part needs to be finished

part numbernormative
300 5009
300 2007

 

extra table with status i need for control

status
Late
In time
first cycle

 

result

part numberfeature_timestampvirsifrastatus
300 50022.09.2021 11:26:34163in time
300 50022.09.2021 11:18:13163late
300 50022.09.2021 11:08:13163in time
300 50022.09.2021 10:59:53163in time
300 50022.09.2021 10:51:33163first cycle
300 20022.09.2021 10:43:12163late
300 20022.09.2021 10:34:52163late
300 20022.09.2021 10:27:22163first cycle

 

If timedifference is less or more as normative for part, correct ststaus shows

Any help is very welcomed

1 user say ditto
472 Views
0 Likes
0 Replies