Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Tags (1)
Community Browser