topic Re: Script in QlikView

Script

mario-sarkis — Fri, 29 May 2015 14:33:14 GMT

Hey all here is my example

ID trx Amount

1211 1 200
1211 1 200

1211 2 300

1211 2 100

I want my result to be like this

ID trx Count(trx) Sum(Amount)

1211 1 2 400

1211 2 2 400

Please how can i write this in the script?

Thank you.

Re: Script

Clever_Anjos — Fri, 29 May 2015 14:38:12 GMT

LOAD

, trx

, Count(trx) as TotalCount

, Sum(Amount) as TotalAmount

resident yourtable

group by ID, trx;

Re: Script

alexandros17 — Fri, 29 May 2015 14:42:48 GMT

TabA:
LOAD * Inline [
ID , trx, Amount

1211 , 1 , 200
1211 , 1 , 200

1211 , 2 , 300

1211 , 2 , 100];

TabB: NoConcatenate
LOAD ID, trx, sum(Amount) as Amount, Count(trx) as num Resident TabA Group By ID, trx;
DROP Table TabA;