topic JOIN on intervals in QlikView https://community.qlik.com/t5/QlikView/JOIN-on-intervals/m-p/223830#M714979 <HTML><HEAD></HEAD><BODY><P>How can I JOIN two tables based on an interval?</P><P>e.g.</P><P>I have an ORDER which goes from 03/05/2009 to 13/06/2009 (european format).</P><P>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?</P><P>Thanks</P></BODY></HTML> Thu, 30 Sep 2010 11:17:37 GMT 2010-09-30T11:17:37Z JOIN on intervals https://community.qlik.com/t5/QlikView/JOIN-on-intervals/m-p/223830#M714979 <HTML><HEAD></HEAD><BODY><P>How can I JOIN two tables based on an interval?</P><P>e.g.</P><P>I have an ORDER which goes from 03/05/2009 to 13/06/2009 (european format).</P><P>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?</P><P>Thanks</P></BODY></HTML> Thu, 30 Sep 2010 11:17:37 GMT https://community.qlik.com/t5/QlikView/JOIN-on-intervals/m-p/223830#M714979 2010-09-30T11:17:37Z JOIN on intervals https://community.qlik.com/t5/QlikView/JOIN-on-intervals/m-p/223831#M714980 <HTML><HEAD></HEAD><BODY><P>Hello Fabianoo</P><P>I'd use intervalmatch following <A href="http://community.qlik.com/forums/p/34022/132351.aspx" title="help using a 'BETWEEN' join on tables from different datasources">this example</A>.</P><P>Hope that helps.</P></BODY></HTML> Thu, 30 Sep 2010 11:52:39 GMT https://community.qlik.com/t5/QlikView/JOIN-on-intervals/m-p/223831#M714980 Miguel_Angel_Baeyens 2010-09-30T11:52:39Z