Logic for HR Qlikview file

amars — Thu, 23 Jul 2009 20:53:35 GMT

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

Logic for HR Qlikview file

johnw — Fri, 24 Jul 2009 02:23:20 GMT

Maybe this?

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

topic Logic for HR Qlikview file in QlikView

Logic for HR Qlikview file

Logic for HR Qlikview file