Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

JOIN on intervals

How can I JOIN two tables based on an interval?

e.g.

I have an ORDER which goes from 03/05/2009 to 13/06/2009 (european format).

How can I join the orders to a table which holds the PROMOTIONS, where I have a promotion which is valid from 01/05/2009 to 15/06/2009?

Thanks

Tags (1)
1 Reply
Miguel_Angel_Baeyens
Not applicable

JOIN on intervals

Hello Fabianoo

I'd use intervalmatch following this example.

Hope that helps.