topic Creating Intervals between list of dates in App Development https://community.qlik.com/t5/App-Development/Creating-Intervals-between-list-of-dates/m-p/1686378#M52273 <P>Hi all,<BR />I have a table with a list of dates:<BR />EmployeeID, BranchID, ContractStartDate<BR />1, 65, 24-06-2019<BR />2, 57, 06-07-2016<BR />3, 23, 13-11-2017<BR />1, 57, 05-03-2018<BR />EmployeeID, Name, PaidDate ,Salary<BR />1, John, 25-07-2019, 2500<BR />1, John, 25-06-2019, 2500<BR />1, John, 25-05-2019, 2000<BR />1, John, 25-04-2019, 2000<BR />1, John, 25-03-2019, 2000<BR />etc...<BR /><BR />I'd like to link these tables:<BR />So when the contract date changes with a different branchID the salaries there after will be linked to that branch.<BR /><BR />Result:<BR />EmployeeID, Name, PaidDate,Salary, Branch ID<BR />1, John, 25-07-2019, 2500 , 65<BR />1, John, 25-06-2019, 2500, 65<BR />1, John, 25-05-2019, 2000, 57<BR />1, John, 25-04-2019, 2000,57<BR />1, John, 25-03-2019, 2000, 57</P> Fri, 20 Mar 2020 07:45:06 GMT ShannaJJ27 2020-03-20T07:45:06Z Creating Intervals between list of dates https://community.qlik.com/t5/App-Development/Creating-Intervals-between-list-of-dates/m-p/1686378#M52273 <P>Hi all,<BR />I have a table with a list of dates:<BR />EmployeeID, BranchID, ContractStartDate<BR />1, 65, 24-06-2019<BR />2, 57, 06-07-2016<BR />3, 23, 13-11-2017<BR />1, 57, 05-03-2018<BR />EmployeeID, Name, PaidDate ,Salary<BR />1, John, 25-07-2019, 2500<BR />1, John, 25-06-2019, 2500<BR />1, John, 25-05-2019, 2000<BR />1, John, 25-04-2019, 2000<BR />1, John, 25-03-2019, 2000<BR />etc...<BR /><BR />I'd like to link these tables:<BR />So when the contract date changes with a different branchID the salaries there after will be linked to that branch.<BR /><BR />Result:<BR />EmployeeID, Name, PaidDate,Salary, Branch ID<BR />1, John, 25-07-2019, 2500 , 65<BR />1, John, 25-06-2019, 2500, 65<BR />1, John, 25-05-2019, 2000, 57<BR />1, John, 25-04-2019, 2000,57<BR />1, John, 25-03-2019, 2000, 57</P> Fri, 20 Mar 2020 07:45:06 GMT https://community.qlik.com/t5/App-Development/Creating-Intervals-between-list-of-dates/m-p/1686378#M52273 ShannaJJ27 2020-03-20T07:45:06Z