topic Re: Rolling 12 months percentages in QlikView

Rolling 12 months percentages

veeranj — Tue, 17 Mar 2015 07:58:42 GMT

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.

Re: Rolling 12 months percentages

Gysbert_Wassenaar — Tue, 17 Mar 2015 09:05:07 GMT

See attached qvw.

Re: Rolling 12 months percentages

aveeeeeee7en — Tue, 17 Mar 2015 09:45:10 GMT

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

Re: Rolling 12 months percentages

Tue, 17 Mar 2015 10:02:28 GMT

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 ?

Re: Rolling 12 months percentages

veeranj — Tue, 17 Mar 2015 10:11:48 GMT

Thanks Gysbert.

That worked .

Regards,

Anjee

Re: Rolling 12 months percentages

Gysbert_Wassenaar — Tue, 17 Mar 2015 14:11:58 GMT

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.