topic Re: Create expression for ACUMULATED values in QlikView

Create expression for ACUMULATED values

Fri, 02 Nov 2012 17:18:32 GMT

Hello

How can I create an expression to accumulate values like shown in the picture:

Thanks!!

Gysbert_Wassenaar — Fri, 02 Nov 2012 17:22:57 GMT

try:

load

day(Fecha_Creacion) as Day,

Empleados,

if(rowno()=1,Empleados,Empleados+peek([Empleados Accum])) as "Empleados Accum"

from .... etc

Fri, 02 Nov 2012 17:39:18 GMT

Thanks Gys

I tried this but can´t seem to get desired result...

Empleados Accum does not exist in the source I am trying to create it as new in the Pivot Chart.

#Empleados is another calculated expression as: count(distinct employeeID) where employeeID is coming from source

diegofcaivano — Fri, 02 Nov 2012 17:53:02 GMT

Hi.

In that case, make a table object with DAY as dimension, EMPLEADOS as a first expression, and a second expression as follows:

EMPLEADOS + BELOW(EMPLEADOS, -1, 0)

Regards.

Edit: To consider the first row, here is the complete expression:

IF(ROWNO()=1, EMPLEADOS, EMPLEADOS + BELOW(EMPLEADOS, -1, 0))

El mensaje fue editado por: Diego Caivano

swuehl — Fri, 02 Nov 2012 17:58:23 GMT

If you want to do this in the chart, there a two options:

a) use a second expression identical to your first

=count(distinct employeeID)

and activate 'full accumulation' in expression tab for that expression.

b) use as second expression

=rangesum(above(count( distinct employeeID),0, rowno() ))

Hope this helps,

Stefan