Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Save interval match table in load script

We manage a customer desk, where several customers come and leave:

Time_ComeTime_Leave
100103
105107
106110
112114

Now we want to match the ships with a calendar,

such as

TimeTime_ComeTime_Leave
100100103
101100103
102100103
103100103
104--
105105107
106105107
106106110
107105107
108106110
109106110
110106110
111--
112112113

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

Tags (1)
Community Browser