We manage a customer desk, where several customers come and leave:
Time_Come | Time_Leave |
---|
100 | 103 |
105 | 107 |
106 | 110 |
112 | 114 |
Now we want to match the ships with a calendar,
such as
Time | Time_Come | Time_Leave |
---|
100 | 100 | 103 |
101 | 100 | 103 |
102 | 100 | 103 |
103 | 100 | 103 |
104 | - | - |
105 | 105 | 107 |
106 | 105 | 107 |
106 | 106 | 110 |
107 | 105 | 107 |
108 | 106 | 110 |
109 | 106 | 110 |
110 | 106 | 110 |
111 | - | - |
112 | 112 | 113 |
This is usually, what reslts ot of an IntervalMatch. But we would like to have it available right after the load script?
The solution presented there is not working though: http://community.qlik.com/message/122414#122414
Does anyone have an idea how to achieve the desired result?
Best,
Jonas