# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Contributor II

## Rolling 12 months percentages

Hi All,

I have  the data as below :

 Attrition Month MonthlyDisengagements Rolling 12 MOnthlyHeadcouint rolling 12months avg Jul 2013 9 9 579 ? Aug 2013 13 22 598 ? Sep 2013 6 28 650 ? Oct 2013 10 38 692 ? Nov 2013 13 51 694 ? Dec 2013 6 57 693 ? Jan 2014 8 65 813 ? Feb 2014 13 78 833 ? Mar 2014 24 102 851 ? Apr 2014 17 119 855 ? May 2014 24 143 851 ? Jun 2014 18 161 855 ? Jul 2014 26 178 864 ? Aug 2014 26 191 874 ? Sep 2014 24 209 882 ? Oct 2014 24 223 884 ? Nov 2014 19 229 890 ? Dec 2014 19 242 889 ? Jan 2015 11 245 894 ? Feb 2015 8 240 908 ?

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.

Tags (4)
1 Solution

Accepted Solutions
MVP & Luminary

## Re: Rolling 12 months percentages

See attached qvw.

talk is cheap, supply exceeds demand
5 Replies
MVP & Luminary

## Re: Rolling 12 months percentages

See attached qvw.

talk is cheap, supply exceeds demand
Valued Contributor III

## Re: Rolling 12 months percentages

Hi

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

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

Regards

Av7eN

Not applicable

## Re: Rolling 12 months percentages

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 ?

Contributor II

Thanks Gysbert.

That worked .

Regards,

Anjee

MVP & Luminary

## Re: Rolling 12 months percentages

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