topic Re: Calculating an attrition rate ? in QlikView

Calculating an attrition rate ?

rastogi_vinayak — Sat, 16 Nov 2024 05:06:38 GMT

Hello Everyone,

How to calculating an Attrition Rate ?

Please give an Idea for expression
Formula – (total no. of employees exited in that Financial Year/ Average no. of employees
in that Financial Year * 100).
Formula for Average no. of employee – (Total no. of employees every month / 12).

for Data Overview Please find the Attachment.

Thank you

Re: Calculating an attrition rate ?

Anil_Babu_Samineni — Thu, 29 Nov 2018 09:55:15 GMT

What do you mean by "Financial Year"

Re: Calculating an attrition rate ?

rastogi_vinayak — Thu, 29 Nov 2018 11:17:09 GMT

Hi @Anil_Babu_Samineni,

if your financial year is from 1 April 2018 to 31 March 2019, then it is known as FY 2018-19.

Re: Calculating an attrition rate ?

Anil_Babu_Samineni — Fri, 30 Nov 2018 03:36:41 GMT

Check this?

(Count({<[Financial Year] = {$(=Max([Financial Year]))}>} employee) / ((Count(TOTAL <Month> employee)/12)*100))