Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

karelibarcar
New Contributor III

Accumulation of Months

Hello world,

I need your help because I have to visualize the information of the value of the account that accumulates month by month, but the information is not displayed as I want.

Imagen1.png


I attach the qvf in case you need it.

Tags (2)
5 Replies
omarbensalem
Esteemed Contributor

Re: Accumulation of Months

what is not correctly accumulated? where? and how would u like it to be?

Some better explanation maybe? so that we can fully understand ur needs and thus could better help u?

karelibarcar
New Contributor III

Re: Accumulation of Months

Hi, I would like it to be like that

Imagen2.png

omarbensalem
Esteemed Contributor

Re: Accumulation of Months

Still don't fully understand what u have and what u want;

but if u have sum(Measure) for example and as a dimension; Month

and u want to show the accumalted Measure ; alter it from

sum(Measure)

to

rangesum(abov(sum(Measure),0,rowno()))

karelibarcar
New Contributor III

Re: Accumulation of Months

It doesn't work.

I have a value called Saldo_Anterior, this value plus other called Movimiento_Cuenta is equal to Saldo_Final, then that Saldo_Final in January 2016 gonna be Saldo_Anterior for February 2016 and then, this plus the respective Movimiento_Cuenta gonna be Saldo_Final and that procedure is repetitive until the selected month. Always it starts in this way, for all Counts that I have.


The result, the total of sum is correct, but I need to visualize the information like I have in Excel. In Qlik, the table is visualizing Movimiento_Cuenta in the three columns measures, so the information is incorrect.

karelibarcar
New Contributor III

Re: Accumulation of Months

I applied your suggestion with rangesum but it gets me others values

Imagen1fsfs.png