HR Dashboard

[#1]

If I want to display the number of employees hired each year, how should i do that?

Say I have a field called year, and another field called employement date?

[buzzy996]

see this,

[richard_chilvers]

I guess you have a table which lists each employee (by EmployeeID) and their employment date ? Don't forget that several people may start on the same day.

Then create a straight table type of Chart, with year of employment as the dimension and COUNT(DISTINCT EmployeeID) as an expression.

[MK_QSL]

You can create flag inside script to find out the employee joined in particular year... Please provide some sample data to work..

[jpenuliar]

Hi Shreya,

you might be able to get inspiration from Qlikview Demo file "Human Resources"

[#6]

You can at the expression level or at the script level. Please find the attachment

[#7]

I am unable to open it, Could you screenshot it maybe?

[buzzy996]

hi,are u tried the one I attached in first post?

[#9]

Yea, Can't open either.

[buzzy996]

try with these files