topic Re: Simple question about how to use Where in join load? in QlikView https://community.qlik.com/t5/QlikView/Simple-question-about-how-to-use-Where-in-join-load/m-p/384955#M1165905 <HTML><HEAD></HEAD><BODY><P>IntervalMatch is what you are looking for. </P></BODY></HTML> Thu, 06 Sep 2012 13:35:37 GMT Gysbert_Wassenaar 2012-09-06T13:35:37Z Simple question about how to use Where in join load? https://community.qlik.com/t5/QlikView/Simple-question-about-how-to-use-Where-in-join-load/m-p/384954#M1165904 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I don´t think this should be any problem to your more expericed user but I´m trying to outer join Table B to Table A but only where B-Date is between (or equal to) StartDate and StopDate in Table A and BType = 82. </P><P></P><P>How should I wright that Where .... ?</P></BODY></HTML> Thu, 06 Sep 2012 13:25:59 GMT https://community.qlik.com/t5/QlikView/Simple-question-about-how-to-use-Where-in-join-load/m-p/384954#M1165904 2012-09-06T13:25:59Z Re: Simple question about how to use Where in join load? https://community.qlik.com/t5/QlikView/Simple-question-about-how-to-use-Where-in-join-load/m-p/384955#M1165905 <HTML><HEAD></HEAD><BODY><P>IntervalMatch is what you are looking for. </P></BODY></HTML> Thu, 06 Sep 2012 13:35:37 GMT https://community.qlik.com/t5/QlikView/Simple-question-about-how-to-use-Where-in-join-load/m-p/384955#M1165905 Gysbert_Wassenaar 2012-09-06T13:35:37Z