Discussion board where members can get started with QlikView.
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!
This should be helpful for you:
Creating Reference Dates for Intervals
and don't make double postings: Split records by predefined time ranges