Skip to main content
Announcements
The New Qlik Learning Experience is Here! GET STARTED
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Split records by predefined time ranges

Hi all,

i would like to split records by predefined time ranges. I got two tables, one for the time ranges and one for the actions:

Every time a record overlaps one or more time ranges, new ranges should be created:

ID_NEWStartTimeEndTime
1_105:3708:00
1_208:0109:10
2_108:4512:00
2_212:0112:15

I'm grateful for any ideas! Best regards!!

QVW attached

0 Replies