Joining on date range.

Gethyn — Thu, 09 Jul 2015 13:36:19 GMT

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.

Thanks,

Gethyn.

Re: Joining on date range.

Gysbert_Wassenaar — Thu, 09 Jul 2015 13:47:52 GMT

That's sounds like you need to use the Intervalmatch function. See this blog post: IntervalMatch.

If there are intervals for each LQLJoin value then you need to use the extended intervalmatch syntax and use the LQLJoin field as the third parameter to the intervalmatch function.

topic Re: Joining on date range. in QlikView

Joining on date range.

Re: Joining on date range.