Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

I want to calculate employee turn over

hi ,

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

4 Replies
kuczynska
Creator III
Creator III

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.

Anonymous
Not applicable
Author

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
Creator II
Creator II

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
Master
Master

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.