topic Re: How to associate 2 tables with a between condition in QlikView https://community.qlik.com/t5/QlikView/How-to-associate-2-tables-with-a-between-condition/m-p/432425#M161188 <HTML><HEAD></HEAD><BODY><P>Use interval Match function for the solution</P><P></P><P>HTh</P><P>Sushil</P></BODY></HTML> Tue, 07 May 2013 07:57:06 GMT sushil353 2013-05-07T07:57:06Z How to associate 2 tables with a between condition https://community.qlik.com/t5/QlikView/How-to-associate-2-tables-with-a-between-condition/m-p/432424#M161187 <HTML><HEAD></HEAD><BODY><P>I have 1 table of prices with start date and end date, like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><P><SPAN style="color: #ffffff;"><STRONG>Price_line_id</STRONG></SPAN></P></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>List Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Item_id</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Start_date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>End_date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Price</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>List1</TD><TD>1</TD><TD>01.01.2012</TD>31.12.2012<TD>10</TD><TD></TD></TR><TR><TD>6</TD><TD>List1</TD><TD>1</TD><TD>01.01.2013</TD>31.12.4100<TD>15</TD><TD></TD></TR><TR><TD>2</TD><TD>List1</TD><TD>2</TD><TD>01.01.2012</TD><TD>31.12.4100</TD><TD>12</TD></TR><TR><TD>3</TD><TD>List2</TD><TD>1</TD><TD>01.01.2012</TD><TD>31.12.2012</TD><TD>11</TD></TR><TR><TD>5</TD><TD>List2</TD><TD>1</TD><TD>01.01.2013</TD><TD>31.12.4100</TD><TD>16</TD></TR><TR><TD>4</TD><TD>List2</TD><TD>3</TD><TD>01.01.2012</TD><TD>31.12.4100</TD><TD>20</TD></TR></TBODY></TABLE><P></P><P>1 other table of orders lines with a date, the price list name and the item.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Order_line</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Order_date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Price List</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Item_id</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Qty</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>30.12.2012</TD><TD>List1</TD><TD>1</TD><TD>10</TD></TR><TR><TD>2</TD><TD>30.12.2012</TD><TD>List1</TD><TD>2</TD><TD>10</TD></TR><TR><TD>3</TD><TD>30.12.2012</TD><TD>List2</TD><TD>1</TD><TD>10</TD></TR><TR><TD>4</TD><TD>03.01.2013</TD><TD>List1</TD><TD>1</TD><TD>10</TD></TR><TR><TD>5</TD><TD>03.01.2013</TD><TD>List2</TD><TD>1</TD><TD>10</TD></TR><TR><TD>6</TD><TD>03.01.2013</TD><TD>List2</TD><TD>3</TD><TD>10</TD></TR></TBODY></TABLE><P></P><P>And i will have this result:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Order_line</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Order_date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Price List</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Item_id</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Qty</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Price_line_id</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Price</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Total</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>30.12.2012</TD><TD>List1</TD><TD>1</TD><TD>10</TD><TD>1</TD>10<TD>100</TD><TD></TD></TR><TR><TD>2</TD><TD>30.12.2012</TD><TD>List1</TD><TD>2</TD><TD>10</TD><TD>2</TD><TD>12</TD><TD>120</TD></TR><TR><TD>3</TD><TD>30.12.2012</TD><TD>List2</TD><TD>1</TD><TD>10</TD><TD>3</TD><TD>11</TD><TD>110</TD></TR><TR><TD>4</TD><TD>03.01.2013</TD><TD>List1</TD><TD>1</TD><TD>10</TD><TD>6</TD><TD>15</TD><TD>150</TD></TR><TR><TD>5</TD><TD>03.01.2013</TD><TD>List2</TD><TD>1</TD><TD>10</TD><TD>5</TD><TD>16</TD><TD>160</TD></TR><TR><TD>6</TD><TD>03.01.2013</TD><TD>List2</TD><TD>3</TD><TD>10</TD><TD>4</TD><TD>20</TD><TD>200</TD></TR></TBODY></TABLE><P></P><P>Easy to explain </P><P></P><P>But i don't have find a solution for linking the price line with the order line with the Order.order_date between the Prices.Start_date and Prices.End_date.&nbsp; </P></BODY></HTML> Tue, 07 May 2013 07:50:44 GMT https://community.qlik.com/t5/QlikView/How-to-associate-2-tables-with-a-between-condition/m-p/432424#M161187 Anonymous 2013-05-07T07:50:44Z Re: How to associate 2 tables with a between condition https://community.qlik.com/t5/QlikView/How-to-associate-2-tables-with-a-between-condition/m-p/432425#M161188 <HTML><HEAD></HEAD><BODY><P>Use interval Match function for the solution</P><P></P><P>HTh</P><P>Sushil</P></BODY></HTML> Tue, 07 May 2013 07:57:06 GMT https://community.qlik.com/t5/QlikView/How-to-associate-2-tables-with-a-between-condition/m-p/432425#M161188 sushil353 2013-05-07T07:57:06Z