Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

robabtcass
New Contributor

Join on date range

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

Tags (1)
1 Reply
ecolomer
Honored Contributor II

Re: Join on date range

Community Browser