Logic for HR Qlikview file

[amars]

Hi all,

I want to develop a HR dashboard like

Now the Data that I have is an As on data, i.e. I have a single entry for all employees , which is having Hire Date & Separation Date as part of data. If the employee is still there Separation date is null. I can't figure out how to draw a graph like the above one with the help of As on Data. Thanks in advance.

Regards

Amar

[johnw]

Maybe this?

count(distinct if( year("Hire Date") <= Year
and ( len("Separation Date") < 1 // testing for null
or year("Separation Date") >= Year),Employee))