Join on date range

[robabtcass]

I have a table with history of billing rates with a Begin and End Date (range) which I need to link to a specific invoice date line.

History table sample

Begin Date      End Date    Title

1/1/14              12/31/14     Jr Associate

1/1/15              12/31/15     Associate

1/1/16               NULL         Sr Associate

For example: If I have an invoice dated 6/15/15, I want to link and only return the title of Associate for this invoice line.

For each invoice (invoice date) I need to return the title as of that invoice date from the table (between the begin and end date).

What is the best and most efficient way in Qlik Sense to accomplish this?

Thanks

Rob

[ecolomer]

You con see this:

Interval Match Feature/Function

IntervalMatch and Slowly Changing Dimensions