1 Reply Latest reply: Mar 18, 2017 2:01 PM by Enrique Colomer RSS

    Join on date range

    Rob Cassiere

      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