Join on date range

robabtcass — Fri, 17 Mar 2017 16:07:18 GMT

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

Re: Join on date range

ecolomer — Sat, 18 Mar 2017 18:01:20 GMT

You con see this: