Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
tomelmslie
New Contributor

Calculating an attrition rate

Hi,

I am trying to calculate and visualise an attrition rate which shows me the rate of attrition month-on-month, but have been unable to calculate it correctly.

I have gone about this by creating my own fields of 'Headcount' and 'Leavers' in order to write the expression. What I have so far, which doesn't give me the right results:

RangeSum(Leavers)/RangeAvg(Above(count(HeadCount),0,12))

'RangeAvg(Above(count(HeadCount),0,12))' correctly displays a moving average of headcount, which is what I want, however 'RangeSum(Leavers)' breaks the formula. The attrition formula I am trying to recreate is:

Sum of leavers (April 2017 - March 2018)/Average Headcount (April 2017 - March 2018)

Any ideas?

Thanks

Labels (2)
3 Replies

Re: Calculating an attrition rate

May be this

RangeSum(Above(Count(Leavers), 0, 12))/
RangeAvg(Above(Count(HeadCount), 0, 12))
tomelmslie
New Contributor

Re: Calculating an attrition rate

I have tried that variation but it didn't work 😞

 

Re: Calculating an attrition rate

Would you be able to share a sample which we can take a look at?