Sum field per group

Tue, 27 Jul 2010 10:27:23 GMT

I'm trying to sum the OpenTime field per CALLID.

Need the total of 239775 to show in all the rows in the next column, do you perhaps know how to do this?

Tried aggr(sum(OpenTime, CALLID) but that doesn't seem to be working.

Thanks

Tue, 27 Jul 2010 11:17:21 GMT

Hi,

Instead of using an Aggr function you can use following

sum(Total <CALLID> OpenTime)

You can modify your Aggr function

sum(aggr(sum(OpenTime),CALLID))

Thanks & Best Regards,

Kuldeep Tak

topic Sum field per group in QlikView