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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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