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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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