topic Re: closing headcount in QlikView

closing headcount

Anonymous — Tue, 29 Nov 2016 06:02:48 GMT

Hi All,

I loaded active employee data from 10/01/1976 to 11/21/2016. I need closing headcount for last and current year by Month wise.

Start Date	End date	Closing Head count (2015)
10/01/1976	01-31-2015
10/01/1976	02-28-2015
10/01/1976	03-31-2015
10/01/1976	04-30-2015
10/01/1976	05-31-2015
10/01/1976	06-30-2015
10/01/1976	07-31-2015
10/01/1976	08-31-2015
10/01/1976	09-30-2015
10/01/1976	10-31-2015
10/01/1976	11-30-2015
10/01/1976	12-31-2015

Thanks,

Krishna

Re: closing headcount

marcus_sommer — Tue, 29 Nov 2016 07:45:01 GMT

You could match your start- and end-date per IntervalMatch with a master-calendar and then just using year as dimension and a simple expression like count(employee).

- Marcus

Re: closing headcount

Anonymous — Tue, 29 Nov 2016 08:22:10 GMT

Hi Krishna,

Kindly refer Number of employees month by month

Re: closing headcount

rido1421 — Tue, 29 Nov 2016 09:11:54 GMT

Hi Krishna

Maybe something like this will work for you ?