Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ShannaJJ27
Partner
Partner

Creating Intervals between list of dates

Hi all,
I have a table with a list of dates:
EmployeeID, BranchID, ContractStartDate
1, 65, 24-06-2019
2, 57, 06-07-2016
3, 23, 13-11-2017
1, 57, 05-03-2018
EmployeeID, Name, PaidDate ,Salary
1, John, 25-07-2019, 2500
1, John, 25-06-2019, 2500
1, John, 25-05-2019, 2000
1, John, 25-04-2019, 2000
1, John, 25-03-2019, 2000
etc...

I'd like to link these tables:
So when the contract date changes with a different branchID the salaries there after will be linked to that branch.

Result:
EmployeeID, Name, PaidDate,Salary, Branch ID
1, John, 25-07-2019, 2500 , 65
1, John, 25-06-2019, 2500, 65
1, John, 25-05-2019, 2000, 57
1, John, 25-04-2019, 2000,57
1, John, 25-03-2019, 2000, 57

0 Replies