Running headcount per month year

[daveesjohn]

Hi,

I want to create a chart that shows the as of / running total headcount of employees based on their hiring date, and exclude resigned employees.
assuming I have a sample data below:

EMP_ID	DATE_HIRED	DATE_RESIGNED
212	01/03/2022
213	01/03/2022
214	02/04/2022
215	02/04/2022	03/01/2022
216	03/04/2022
217	03/05/2022
218	03/05/2022	04/02/2022
219	04/05/2022
220	04/05/2022

the result should be

MONTH_DATE	HEAD_COUNT
JAN 2022	2
FEB 2022	4
MAR 2022	6
APR 2022	7

Thank you

[MayilVahanan]

HI

Try like below

Exp: Rangesum(Above(Count(DISTINCT EMP_ID), 0, RowNo(Total)))

[daveesjohn]

Hi @MayilVahanan 

Thanks for your feedback, it's working, but I forgot what If we have additional field such as "DATE_RESIGNED" wherein we only need to count the Active employees as of the current running date and year

[MarcoWedel]

maybe helpful:

https://community.qlik.com/t5/QlikView-App-Dev/Reference-DateTime-for-calculating-occupancy/m-p/1282...

https://community.qlik.com/t5/QlikView-App-Dev/Count-records-per-day-or-week-between-two-dates-Conta...