1 Reply Latest reply: Jul 9, 2015 9:47 AM by Gysbert Wassenaar RSS

    Joining on date range.

    Gethyn Owen

      Hi Everyone,

       

      I have a QlikView document containing the tables shown in the image below. For the join between the HCDs and LQL tables I need to join by the LQLJoin fields but I also need to be able to limit it to where HCDs.[Admin Date] is between LQL.IMP_DATE and LQL.END_DATE the IMP_DATE field is always populated but the END_DATE field can be null.

       

      Table Joins.bmp

       

      Thanks,

       

      Gethyn.