Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

anjeepvr
Contributor 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
MVP & Luminary
MVP & Luminary

Re: Rolling 12 months percentages

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
MVP & Luminary
MVP & Luminary

Re: Rolling 12 months percentages

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

aveeeeeee7en
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))

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

Regards

Av7eN

Highlighted
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 ?

anjeepvr
Contributor II

Re: Rolling 12 months percentages

Thanks Gysbert.

That worked .

Regards,

Anjee

MVP & Luminary
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