Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

Filtering Duration and linked condition over several rows

Hello,

I have a sample data here:

QueueNo.ActionNo.ActionNameStartFinished
11115000Start08:0008:05
11115001Moving08:0508:10
11115002Parking08:1008:12
11115003Moving08:1208:29
11115004Success08:2908:30
22225100Start09:0009:00
22225101Moving09:0109:10
22225102Failed09:1009:10

 

Its a wagon which is moving automatically and creates data of every action it does.  As you can see,  only the  distinct Queuenumber distinguish if the whole Mission with its tiny subactions are belonging together.  Different mission can have totally different Actions.  Between different continuous actions there is no gap in time. Now I want to know the duration  from the very first  start of a mission to the very last action of that sameQueueNo. For QueueNo: 1111 I want to get 30minutes duration time. And for 2222 it would be 10minutes. 

The second thing I need to filter is the count of these QueueNo. which has a 'start' and a 'success' ending and  the same also for other processes, when e.g. the process 'failed'. 

I hope  I explained well. 

Thank you very much. Stay safe.

Best. 

 

0 Replies