topic Re: head count in QlikView

head count

nareshthavidishetty — Mon, 30 Nov 2015 13:43:49 GMT

HI all,

i'm building the HR dashboard in that i need to calculate the headcount of the employee can anyone plz help me regarding this one

basically i'm struck in script part don't know where to start plz help me

i got tables like employees,internal candidate,external candidate,gender,employeetype etc

overall tables 20

i need to count the employe statistics,headcount so on

Re: head count

nigel987 — Mon, 30 Nov 2015 13:45:37 GMT

Try something like:

=count(distinct employeeID)

Re: head count

Anonymous — Mon, 30 Nov 2015 13:46:13 GMT

For Headcount...Employee details are required.

Use Employee ID or may be Staff ID to get Head Count.

Total HeadCount : Count(Distinct EmployeeID) //this will give you total headcount

Re: head count

nareshthavidishetty — Mon, 30 Nov 2015 13:46:49 GMT

yea i tried that one ,but the data is in the hirearchy

Re: head count

nigel987 — Mon, 30 Nov 2015 13:47:57 GMT

Can you post your qvw here?

Re: head count

Kushal_Chawda — Mon, 30 Nov 2015 13:49:59 GMT

Firstly, need to know the logic of getting Headcount. Secondly need to know the table mappings.

Re: head count

Mon, 30 Nov 2015 13:50:03 GMT

Hi Naresh,

I think if you did this front end (i.e. not in script) a formula along the lines of…

=Count(DISTINCT [EmployeeIdField])

would give you headcount.

Regards,

Jason.

Re: head count

nareshthavidishetty — Mon, 30 Nov 2015 15:29:46 GMT

can anyone tell me how to calculate the staffing rate and tenure

Re: head count

datagrrl — Mon, 30 Nov 2015 15:53:33 GMT

These are most likely operational definitions within your organization. For example at my company we have groups, like new employees(<1 year),1-5 years, 5-10...etc.

I am not sure what staffing rate means and I don't know what data you are working with.

Re: head count

nareshthavidishetty — Mon, 30 Nov 2015 15:59:21 GMT

Hi DataGrrl,

thanks for the reply im just working on normal data which consists of employee details and designations,project assignments,employee type,internal candidate,external candidate,gender,businessunits buket config etc

Re: head count

Mon, 30 Nov 2015 16:19:59 GMT

Tenure is how long one employee worked for your company. Normally, it's today - hire date.

Re: head count

Peter_Cammaert — Mon, 30 Nov 2015 16:36:28 GMT

A few suggestions:

First define your business case. What do you want to show? "Rate, tenure and so on" is not much like a business case. Make an inventory of the different Questions you want to answer.

Then try to define how this business logic can be implemented. For example: for the calculation of Employee Tenure, what do you need and how do you calculate its value.

Then (and not least important), decide on your timeline. Will you report by month, by Quarter, by year, by week? How far do you want to go back? 2yrs? 5 yrs? 10 yrs? 100yrs?

Based on this case description, decide on what source tables you really need, and which ones you can throw out. Then try to merge the information in these tables. By simplifying your data model, your documents and objects will be easier to design & build.

Now, import the tables your really need in an empty QVW document. Once you get here, you will face the task of tuning your LOAD statements in order to create an efficient data model. That's where we can help with specific solutions for your problems.

Best,

Peter

Re: head count

nareshthavidishetty — Mon, 30 Nov 2015 16:37:13 GMT

i used

Interval(today(1) -HireDate,'D') as days to calculate days

for calculating months

(((year(today(1))*12)+month(today(1))) - (((year([Hire Date])*12)+month([Hire Date]))))