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: 
Not applicable

Grouping by continuous dates

Hi !
I have a table like this:

StepStartEnd
Step 116/06/2013  09:01:4316/06/2013  09:11:17
Step 216/06/2013  09:11:1716/06/2013  09:16:29
Step 316/06/2013  09:16:29

16/06/2013  10:47:30

Step 416/06/2013  11:05:2016/06/2013 11:05:45
Step 516/06/2013 11:05:4516/06/2013 11:14:09

In the LOAD process I would like to finish with this:

TimeStartEnd
01:45:4716/06/2013 09:01:4316/06/2013 10:47:30

Steps 4 and 5 are not selected because they sum less then 15 minutes.
Is it possible to achieve this ?

Thanks in advance !

Regards,
Itamar

0 Replies