Attration %

[Satish251]

Hello All,

I am Looking for solution for below KPI's ( Qlik Sense).

I have to disply this value with button as toggle on Line chart ,

need help for denominator KPI Value for TTM and YTD.

Attrition Rate (TTM): Number of Employees Who Left / (Average number of employees during the same 12-month period)
Attrition Rate (YTD) : Number of Employees Who Left / (Average number of employees starting from January to current month)

I have attached Sample Data, and Date field to be used is "System Date".

output :