Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Split records by predefined time ranges

Hi all,

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

New records should be created when an action overlaps with one or more time ranges (see table below)!

QVW is attached.

I'm grateful for any ideas!

Best regards!

 

ID_NEWStartTimeEndTime
1_105:37:0008:00:00
1_208:01:0009:10:00
2_108:45:0012:00:00
2_212:01:0012:15:00
3_113:05:0014:00:00
3_214:01:0018:00:00
3_318:01:0021:10:00
1 Reply
MVP & Luminary
MVP & Luminary

Re: Split records by predefined time ranges

This should be helpful for you:

Creating Reference Dates for Intervals

IntervalMatch

and don't make double postings: Split records by predefined time ranges

- Marcus