Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Gethyn
Creator
Creator

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
Gysbert_Wassenaar

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

View solution in original post

1 Reply
Gysbert_Wassenaar

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