topic Re: Rolling 12 months Sum in App Development

Rolling 12 months Sum

ChloeA — Wed, 28 May 2025 19:54:24 GMT

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".

Re: Rolling 12 months Sum

-SW- — Wed, 28 May 2025 22:08:59 GMT

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

Re: Rolling 12 months Sum

ChloeA — Thu, 29 May 2025 20:24:21 GMT

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.

Re: Rolling 12 months Sum

rafaelencinas — Mon, 02 Jun 2025 01:10:01 GMT

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!

Re: Rolling 12 months Sum

ChloeA — Tue, 03 Jun 2025 20:36:16 GMT

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

Re: Rolling 12 months Sum

rafaelencinas — Tue, 03 Jun 2025 21:03:28 GMT

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!