Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
karelibarcar
Contributor III
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.

5 Replies
OmarBenSalem

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
Contributor III
Contributor III
Author

Hi, I would like it to be like that

Imagen2.png

OmarBenSalem

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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

Imagen1fsfs.png