Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
Hi
Please find the solution attached.
Hi,
Can you check this link https://community.qlik.com/t5/QlikView-App-Development/Employee-headcount-based-date-of-resignation/...
ive used that . please look into the application.
Hi
Please find the solution attached.