Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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

0 Replies