Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
veeranj
Creator II
Creator II

Rolling 12 months percentages

Hi All,

I have  the data as below :

Attrition MonthMonthlyDisengagementsRolling 12MOnthlyHeadcouintrolling 12months avg
Jul 201399579?
Aug 20131322598?
Sep 2013628650?
Oct 20131038692?
Nov 20131351694?
Dec 2013657693?
Jan 2014865813?
Feb 20141378833?
Mar 201424102851?
Apr 201417119855?
May 201424143851?
Jun 201418161855?
Jul 201426178864?
Aug 201426191874?
Sep 201424209882?
Oct 201424223884?
Nov 201419229890?
Dec 201419242889?
Jan 201511245894?
Feb 20158240908?

Now i have to calculate the percentages  for each month like

for the month of JULY it will be 9/579 and for AUG it should be (9+13)/avg(579+598)
for month of Sep it should be 9+13+6/Avg(579+598+650)

Can anyone help me on this.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
aveeeeeee7en
Specialist III
Specialist III

Hi

You can Try RangeSum() & RangeAvg() Functions to achieve the desired Result.

RangeSum(Above(Sum(MonthlyDisengagements),0,3))

RangeAvg(Above(Sum(MOnthlyHeadcouint),0,3))

Regards

Av7eN

Not applicable

Hi Gysbert,

your solution seems correct, but why are you recalculating the [rolling 12] values that are already provided in the data source ? I used [Rolling 12]/avg({<Period={'Rolling 12'}>}MOnthlyHeadcouint) for rolling 12months avg2 for the same results. Question from a Newbie, is there any difference, or some method is more efficient than another ?

veeranj
Creator II
Creator II
Author

Thanks Gysbert.

That worked .

Regards,

Anjee

Gysbert_Wassenaar

I assumed that those values are not part of the source data, but merely added as example result values in the starting post of this discussion.


talk is cheap, supply exceeds demand