topic intervalmatch in QlikView https://community.qlik.com/t5/QlikView/intervalmatch/m-p/201964#M59835 <HTML><HEAD></HEAD><BODY><P>Have a look into the extended syntax of the IntervalMatch</P><P>sample is attached (already joining the tables together i/o to avoid a synthetic key)</P><P>HTH<BR />Peter</P></BODY></HTML> Sun, 06 Feb 2011 11:12:33 GMT prieper 2011-02-06T11:12:33Z intervalmatch https://community.qlik.com/t5/QlikView/intervalmatch/m-p/201963#M59834 <HTML><HEAD></HEAD><BODY><P>I have a problem with de combination orderdate per product and to combine the salesprice with the right costprice.</P><P>Example:</P><P>Tabel 1 :</P><P>product date from date till costprice</P><P>a 1-1-2010 28-2-2010 5,50</P><P>a 1-3-2010 20-3-2010 9,90</P><P>b 11-11-2009 18-2-2010 1,25</P><P>b 19-2-2010 31-3-2010 2,20</P><P></P><P>Tabel 2:</P><P>Order Orderdate Orderline product salesprice</P><P>98001 01-01-2010 1 a 12,50</P><P>98001 01-01-2010 2 b 5,90</P><P>98002 01-03-2010 1 a 15,50</P><P>IntervalMatch(orderdate) gives double records because there are more products per date selection.</P><P>Please can someone give me the right solution?</P><P>Thanks</P></BODY></HTML> Sat, 05 Feb 2011 17:15:09 GMT https://community.qlik.com/t5/QlikView/intervalmatch/m-p/201963#M59834 2011-02-05T17:15:09Z intervalmatch https://community.qlik.com/t5/QlikView/intervalmatch/m-p/201964#M59835 <HTML><HEAD></HEAD><BODY><P>Have a look into the extended syntax of the IntervalMatch</P><P>sample is attached (already joining the tables together i/o to avoid a synthetic key)</P><P>HTH<BR />Peter</P></BODY></HTML> Sun, 06 Feb 2011 11:12:33 GMT https://community.qlik.com/t5/QlikView/intervalmatch/m-p/201964#M59835 prieper 2011-02-06T11:12:33Z intervalmatch https://community.qlik.com/t5/QlikView/intervalmatch/m-p/201965#M59836 <HTML><HEAD></HEAD><BODY><P>Thanks Peter</P></BODY></HTML> Mon, 07 Feb 2011 16:40:10 GMT https://community.qlik.com/t5/QlikView/intervalmatch/m-p/201965#M59836 2011-02-07T16:40:10Z