Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

krishna4bo
Contributor

closing headcount

 

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

Tags (1)
3 Replies
MVP & Luminary
MVP & Luminary

Re: closing headcount

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

payalgosar
Contributor II

Re: closing headcount

Hi Krishna,

Kindly refer Number of employees month by month

rido1421
Contributor III

Re: closing headcount

Hi Krishna

Maybe something like this will work for you ?