Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

amirjabbar1900
New Contributor

I want to calculate employee turn over

hi ,

i m creating HR dashboard , and need to calculate employee turn over

4 Replies
kuczynska
Contributor III

Re: I want to calculate employee turn over

Hi,

what is your question here? Are you looking for a employee turnover definition? If so - employee turnover refers to number of percentage of workers who leave organization and are replaced by new employees. But you should definitely confirm this definition with the users and data owners.

amirjabbar1900
New Contributor

Re: I want to calculate employee turn over

7929e7c1ca6449b7a145f6f8f763107b.jpg

this is my employee turn over table . now i m trying to use , kpi chart or gauge chart to show on dashboard .

shanky1907
Contributor II

Re: I want to calculate employee turn over

Please refre first the below thread to design a good gauge chart:

Creating a Good Looking Gauge Chart in Qlikview

I think it will solve your issue and help you to build a chart of your requirement.

rittermd
Honored Contributor

Re: I want to calculate employee turn over

You really need to define what you want to calculate.  Do you want to know the termination rate for this year only or for all time?

Based on your data example it looks like you just need an expression that is  total fired / total hired.

If you wanted the Retention Rate instead it would be the opposite.

Community Browser