Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
fallenangel6
Contributor

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
];

1 Solution

Accepted Solutions
MarkWillems
New Contributor III

Re: Emp Joined and Resigned in a month

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

Re: Emp Joined and Resigned in a month

fallenangel6
Contributor

Re: Emp Joined and Resigned in a month

ive used that . please look into the application.

MarkWillems
New Contributor III

Re: Emp Joined and Resigned in a month

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