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: 
Not applicable

creation of a column with the accumulated

Hello:

I have a problem about the creation of a column with the accumulated value when the table has more than one dimension (I'm not sure if this will be a hindrance).

I want to create a new column with the cumulative sales, called %VENTAS ACUM, whose expression % is (Sum (VALOR_NETO_MOV) / Sum (TOTAL VALOR_NETO_MOV)), the problem is that when I want to create this column selecting "full accumulation" is not generated and it shows the same as the column %VENTAS, that it has the same expression without "full acumulation". In this table I have 2 dimenssions,

Now I found that when using only one dimension that I have on my my table, the results of %VENTAS and %VENTAS ACUM are correct.

I tried with the formula IF(Rowno () = 1, [% row] [% row] + above ([% Cumulative row.])), but the results of %VENTA and %VENTAS ACUM are the same too,

HELP ME PLEASE!!

16 Replies
Not applicable
Author

tabla.png

This is my table, where RUT and NOMBRE CLIENTE are dimensions. How you can see, the columns % VTA and % VTA ACUM has the same results. The reason was wrote in the last post. But, if RUT or NOMBRE CLIENTE were alone in the table, the results of both columns were correct.

I need a formula that allows me to have both columns with the correct value, despite having two dimensions in the table.

May you help us?

sebastiandperei
Specialist
Specialist

Hola!

Probá con:

RangeSum (Sum (VALOR_NETO_MOV) / Sum (TOTAL VALOR_NETO_MOV)), Above(Sum (VALOR_NETO_MOV) / Sum (TOTAL VALOR_NETO_MOV)))

Not applicable
Author

Sebastian probe con esa formula y no hay cambio, todos los valores son cero, se puede con alguna otra formula???

whiteline
Master II
Master II

First of all in your case you need to accumulate only numerator.

=RangeSum (Above(Sum (VALOR_NETO_MOV), 0, RowNo()) / Sum (TOTAL VALOR_NETO_MOV)

Not applicable
Author

do not need that, I just need the cumulative column % vta (Sum (VALOR_NETO_MOV) / Sum (TOTAL VALOR_NETO_MOV)

sebastiandperei
Specialist
Specialist

Mandá una copia reducida

whiteline
Master II
Master II

=RangeSum (Above(Sum (VALOR_NETO_MOV)/Sum (TOTAL VALOR_NETO_MOV), 0, RowNo()))

sebastiandperei
Specialist
Specialist

Perdón!!!

Revisando la fórmula, encontré que hay mal un paréntesis. La fórmula sería:

RangeSum (Sum (VALOR_NETO_MOV) / Sum (TOTAL VALOR_NETO_MOV), Above(Sum (VALOR_NETO_MOV) / Sum (TOTAL VALOR_NETO_MOV)))

Y no le des bola a los anglos!! Jeje

whiteline
Master II
Master II

2 Sebastian Pereira:

Your formula:

=RangeSum ([Some Expression], Above([Some Expression]))

gives accumulation with one step back. It's not full accumulation.