Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fallenangel6
Creator
Creator

Emp Joined and Resigned in a month

Hi All,

Can someone help me find the emp joined and emp resigned every month. i used interval match to find the active employees in a month. i have 30k ids and so i generated YYYYMM instead of individual dates as it is not feasible. please help me on how to find the emp joined in a month and emp resigned in a month.

Sample data:

load * inline
[ empid,join,resign
1,01-09-2018,
2,02-05-2016,12-04-2019
3,30-04-2018,02-05-2019
4,30-04-2018,02-04-2019
5,30-04-2018,02-06-2019
6,01-04-2018,30-05-2018
];

Labels (3)
1 Solution

Accepted Solutions
MarkWillems
Contributor III
Contributor III

Hi

Please find the solution attached.

 

 

Hey, Please don't forget to add kudos, like or mark as a solution if my reply has helped you at all! 🙂

View solution in original post

3 Replies
fallenangel6
Creator
Creator
Author

ive used that . please look into the application.

MarkWillems
Contributor III
Contributor III

Hi

Please find the solution attached.

 

 

Hey, Please don't forget to add kudos, like or mark as a solution if my reply has helped you at all! 🙂