First of all i would like to thank everybody for the great input on this forum, it has been a big help for me getting used to Qlikview.
For the first time i have ran into a "problem" i couldn't solve by searching this forum (probably because i don't know how to describe the problem).
I am trying to replicate the workschedules from our employees in Qlikview.
What i'm trying to do is link the schedule to actual working times and see if there's overtime.
The problem i run into is that the schedule has a start day, for example the first line in table 1 means that the schedule starts on Tuesday (2) 26-12-2006. I want to add the schedule (Table 2) 7:30/16:00 (inz/rei) starting from day 2 and loop it ending at 31-12-9999 (or any other end date set in table 1).
Another dificulty is that the schedule in table 2 could be any number of lines long (example 1 week schedule will have 7 lines, 2 week schedule will have 14 lines etc.)
I made a example for the expected result at the bottom of my question.
Thanks in advance for helping me solve my riddle!
The data tables look like this (short example):
Table 1: Start and end date for a schedule
Table 2: Specification for the schedule (describes the working time per day of the week 1 is monday etc)