topic Re: Between in QlikView in QlikView https://community.qlik.com/t5/QlikView/Between-in-QlikView/m-p/488283#M687014 <HTML><HEAD></HEAD><BODY><P>Thanks! Steve</P></BODY></HTML> Mon, 25 Nov 2013 18:06:13 GMT zagzebski 2013-11-25T18:06:13Z Between in QlikView https://community.qlik.com/t5/QlikView/Between-in-QlikView/m-p/488281#M687012 <HTML><HEAD></HEAD><BODY><P>I need to left join the F_Revenue table to the Dept_Activation table by the Dept field AND where the Service Date on the F_Revenue table is between the Active_Begin_Date and Active_End_Date. Looking for help on how to code the where clause to make this happen? </P><P></P><P>F_Revenue:</P><P>Dept,</P><P>Revenue,</P><P>Service Date</P><P>Resident Revenue</P><P></P><P>Left Join (F_Revenue)</P><P>Dept</P><P>Active_Begin_Date</P><P>Active_End_Date</P><P>Resident Dept</P><P>WHERE</P><P></P><P>Thanks,</P><P></P><P>Steve</P></BODY></HTML> Mon, 25 Nov 2013 17:54:45 GMT https://community.qlik.com/t5/QlikView/Between-in-QlikView/m-p/488281#M687012 zagzebski 2013-11-25T17:54:45Z Re: Between in QlikView https://community.qlik.com/t5/QlikView/Between-in-QlikView/m-p/488282#M687013 <HTML><HEAD></HEAD><BODY><P>Check your manual for INTERVALMATCH, is what you need</P></BODY></HTML> Mon, 25 Nov 2013 18:04:20 GMT https://community.qlik.com/t5/QlikView/Between-in-QlikView/m-p/488282#M687013 Clever_Anjos 2013-11-25T18:04:20Z Re: Between in QlikView https://community.qlik.com/t5/QlikView/Between-in-QlikView/m-p/488283#M687014 <HTML><HEAD></HEAD><BODY><P>Thanks! Steve</P></BODY></HTML> Mon, 25 Nov 2013 18:06:13 GMT https://community.qlik.com/t5/QlikView/Between-in-QlikView/m-p/488283#M687014 zagzebski 2013-11-25T18:06:13Z