Interval Match

[#1]

Hey Guys.

Can anyone give me a good basic example of an interval match? Ive searched the forums but all the ones I came accross were a bit to confusing for me. I want to try and use Interval Match in one of my projects but I don't understand it properly.

[#2 · Accepted solution]

Check this post http://community.qlik.com/forums/t/23510.aspx

I've tried to explain there how to replace IntervalMatch by usual Load statements. Maybe it can help.

[#3]

Worked like a bomb. Thanks so so so much.

got another problem though. When the Interval Match completes, it creates a sysnthetic table. How do i get rid of that?

[Caique_Zaniolo]

Try a left join() to your main table.

[#5]

I have already but its not working.

LEFT JOIN('MainTable')

[martin59]

LEFT JOIN(MainTable) // without quotes

[#7]

No that doesnt work...sorry...

[martin59]

Could you send a screenshot of your data model ?

[#9]

[#10]

It will be better to see your load script.

[#11]

its cool guys, i found this which helped me greatly,

http://community.qlik.com/forums/t/17847.aspx