topic Conditional sum (for different group) in QlikView

Conditional sum (for different group)

Sat, 21 Nov 2009 00:26:55 GMT

Hi everyone,

I would like to do a sum(aggr())in script if possible since my pc is really slow in doing further calculation based on that.

Case like. I have a list of ID, all with there teams. example:

ID, team, fee

1,A,3

2,B,5

3,A,8

etc.

There are about 200000 unique ID and 4 teams. How can I add up all fees belonging to the same team in script, but not using aggr/partial sum in pivot table.

Many thanks,

Ivan

Conditional sum (for different group)

Anonymous — Sat, 21 Nov 2009 00:40:18 GMT

Proabably what you can do is write SQL and make a new field to get the sum using group by statement (cretea a new temp table and use join to attach to the original table). use avg(newfle) in the pivot table- carefull it should pivot on the same group else you will have differnt answer.

Conditional sum (for different group)

rwunderlich — Sat, 21 Nov 2009 01:45:26 GMT

SumFees:
LOAD
team,
sum(fee) as "Total Fee"
RESIDENT data
GROUP BY team
;

-Rob

Conditional sum (for different group)

Mon, 23 Nov 2009 15:31:11 GMT

Hi Rob,

Thanks to your suggestion. It's work. However, I have something similar here that fields are not from one table, fields are from several tables which linked in Qlikview. I try to use 'from field' to do it. But there is something wrong....

Regards,

Ivan