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: 
Not applicable

Show Headcount for New Hires and Termed Employees with interval match

Hi,

I am trying to setup a chart for employee headcount by month which I have been able to do by using interval match. However, I am not sure how to show only new hires or termed employees for the month in same chart(ideally) or similar chart. For example, in the attached screen shot I would like to see 2 new hires and 1 termed employee for March and the overall headcount is 6.  I have also attached a QVW with the example data.  Thanks for the help!!

QlikQuest1.PNG

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Add two expressions:

New:

=Count(DISTINCT If(Month= Month(HR_Start_Date),EMP_ID))

Termed:

=Count(DISTINCT If(Month= Month(HR_End_Date),EMP_ID))

View solution in original post

4 Replies
swuehl
MVP
MVP

Add two expressions:

New:

=Count(DISTINCT If(Month= Month(HR_Start_Date),EMP_ID))

Termed:

=Count(DISTINCT If(Month= Month(HR_End_Date),EMP_ID))

sunny_talwar

This?

Capture.PNG

Expression for New Hires: =Sum(If(HR_Start_Date = Date, 1, 0))

Expression for Termed:      =Sum(If(HR_End_Date = Date, 1, 0))

sunny_talwar

Or this kind of a stacked bar chart visual:

Capture.PNG

Not applicable
Author

Thanks Swuel and SunnT! exactly what I wanted.  I like the stacked visual idea too.