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: 
sunitha_chellaiah
Partner - Creator
Partner - Creator

How to calculate opening and closing head count of employees

Hi All

I want to calculate opening headcount of employees and closing headcount of employees. I have data as shown below

LOAD 
EMPID,
EMPLOYEE,
LOCATION,
FUNCTION,
POSITION,
DOJ,
DOL,
FROM
.......................;

 formula to calculate the opening and closing are given below

Opening balance = closing of the last month

Hiring = Current month joining

Leaving = Current month Leaving

Closing Balance= Opening + Hiring-leaving

 

can someone help me to achieve this requirement

2 Replies
sunitha_chellaiah
Partner - Creator
Partner - Creator
Author

Hi @Henric_Cronström  Sir, Can you please help me to solve this.

Agnes92
Contributor
Contributor

Many organizations do use a form of average headcount in their calculations. Instead of taking the beginning or start of year, they will take the EOP Headcount for each employee for each month and average across the year.

 

 

skylightpaycard