topic Transform and Generate a new table in script in QlikView

Transform and Generate a new table in script

ecolomer — Wed, 12 Oct 2016 03:55:05 GMT

I have an table with the position of the accounts (POS) to a certain date

Cuenta - Fecha - Posición

and another with the movements each day (MOV)

Cuenta - Fecha - Importe

I want to get a table with the following data:

Cuenta - Fecha - Entradas - Salidas - Posición

with one record for each date.

Where "Entradas" = sum(Importe if >0) and "Salidas" = sum(Importe if <0)

Thank's for your help

jonathandienst — Wed, 12 Oct 2016 04:33:10 GMT

Is this what you are after?

Temp:

LOAD Cuenta,

Fecha,

Posición

FROM ... ;

Join(Temp)

LOAD Cuenta,

Fecha,

Importe

FROM ... ;

Final:

LOAD Cuenta,

Fecha,

Posición,

Sum(RangeMax(Importe, 0)) as Entradas,

Sum(RangeMin(Importe, 0)) as Salidas

Resident Temp

Group By Cuenta,

Fecha,

Posición;

DROP TABLE Temp;

ecolomer — Wed, 12 Oct 2016 05:00:24 GMT

Thank's for your response, but is not that.

I explain more.with an example.

Table POS

Cuenta	Fecha	Posición
0128 9464 40 0100014362	11/10/2016	2.905,24

Table MOV

The expected result I upload an excel example