topic Re: Employee attrition calculation in QlikView

Employee attrition calculation

santhoo_san — Wed, 16 Jan 2013 14:49:22 GMT

Hi,

I have a set of data of employees for two months, where in I do not have any employee joining or releaving dates. But, I have to identify the Addition and Deletion of employees by comparing the employee IDs. (means if an employee ID available in the previous month and not available in the current month identify it as deletion of employee. similarly if an employee ID is not available in the previous month and available in the curent month that is addition). I have attached sample data. Please suggest.

Regards,

Santhosh

Re: Employee attrition calculation

danielrozental — Wed, 16 Jan 2013 15:00:56 GMT

Santhosh, you might want to consider adding empty rows in months where you don't have data.

Re: Employee attrition calculation

santhoo_san — Thu, 17 Jan 2013 07:59:50 GMT

Hi Daniel,

I did not understand how this would help in comparing the data.

Re: Employee attrition calculation

Thu, 17 Jan 2013 08:52:20 GMT

Hi Santosh,

You can use Mapping table to check out the presence of EMP ID for respective months

EX :

TBL 1:

Previous month

TBL 2

Present Month

Use Applymap function in your main table to check the presence

Hope this helps

Regards

Mallik

Re: Employee attrition calculation

Thu, 17 Jan 2013 08:52:41 GMT

Hi Santosh,

You can use Mapping table to check out the presence of EMP ID for respective months

EX :

TBL 1:

Previous month

TBL 2

Present Month

Use Applymap function in your main table to check the presence

Hope this helps

Regards

Mallik

Re: Employee attrition calculation

Thu, 17 Jan 2013 08:59:14 GMT

Hi Santhosh,

create table employees: as concatenate load for both month with an additional attribute LoadDate as for Excel column D.

then load as table diff: EmpID and Count(LoadDate) #emp grouping by EmpID

next join that diff with employees where #emp = 1 and LoadDate is not the new load date

these are the ones from the old load that do not reappear in the new load => the deleted ones.

Ciao

Klaus