Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Gethyn
Contributor

Joining on date range.

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Joining on date range.

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.


talk is cheap, supply exceeds demand
1 Reply
MVP & Luminary
MVP & Luminary

Re: Joining on date range.

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.


talk is cheap, supply exceeds demand