Calculating the rolling 12 months sum and displaying it from the middle of the months

[veeranj]

Hi All,

i have the data as below

SS,Attrmnth,Monthdisengagemens

SS1,JULY 2013,10

SS2,AUG 2013

Header 1	Header 2	Header 3
SS	MONTH	DISENGAGEMENTS
SS1	JULY 2014	10
SS1	AUG 2014	9
SS1	SEP 2014	2
SS1	OCT 2014	5
SS1	NOV 2014	6
SS1	DEC 2014	2
SS1	JAN 2014	1
SS1	FEB 2014	2
SS1	MAR 2014	2
SS11	APRIL 2014	1
SS1	MAY 2014	2

I have to show in the pivot table the past cumulative 12 months sum of disengagemnets where months are transposed.
For EX: For july it is same as 10.

For Aug,it should be sum of Aug and  July(10+9).

this is am able to get using the below  expression if i display the data from July 2014

rangesum(BEFORE ( sum( MnthlyDisEngCount),0,12)).

Here the record is starting from July 2014 so we have no problem in writing the above expression.

But the requirement is i want to show this data only from the Year 2014 only.
When i am filtering this data for the month of year=2014 in the dimension itself,i am not getting the desired result.
But from the month of Jan 2014,it should give the summation of past 12 months data .
Can any one help me on this.

Thanks,

Anjee

[segador_]

Hi

You need to add second calendar

Like this

http://community.qlik.com/message/733201#733201

[veeranj]

Hi,

That we can achive using AS of tables.

but  do we have an option of doing it using rangesum functions.

Thanks,

Anjee

[segador_]

Unfortunately RangeSum does not work with Set analysis... And after any selection of calendar formula using RangeSum will not work as you need.