Transform and Generate a new table in script - Qlik Community

ecolomer · ‎2016-10-11

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 · ‎2016-10-12

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;

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

ecolomer · ‎2016-10-12

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