Rolling 12 months Sum

[ChloeA]

I have a dataset with the premium and paid amount in each month. I want to show the rolling 12 months sum of the premium and paid in a table on QLik. Does anyone know how to do it? Thanks.

I have attached a excel with a sample of my dataset on tab "Dataset" and my desired Qlik table on tab "QLik Dashboard".

[-SW-]

try
RangeSum(Above(Sum({<Period,dimension={'Paid'}>}value),0,12))
and
RangeSum(Above(Sum({<Period,dimension={'Premium'}>}value),0,12))

[ChloeA]

Thanks for your reply SW.

Sorry I should mention there are some extra challenges in my dataset.

Firstly, the dataset is in a random order of period.

Secondly, there could be more than 1 row for each period and I need to sum them up.

Attached is an updated sample of my dataset.

[rafaelencinas]

Hi !

This is my sollution for you:

1 - Create a new Field named PeriodID 

(Num#(Left(Period,4))*12) + Num#(Right(Period,2)) as PeriodID

2 - Create a table with only one dimension Period

3 - Check my attachments.

Bye!

[ChloeA]

Sorry I could not open the qvf file. Is it possible to share the formula here? 

[rafaelencinas]

Sure!

Accumulation 12 Months Paid

RangeSum(Above(Sum({<dimension={'Paid'}>} value),0,12))

Accumulation 12 Months Premium

RangeSum(Above(Sum({<dimension={'Premium'}>} value),0,12))

Bye!