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?