Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum field per group

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.



error loading image

Thanks



1 Reply
Not applicable
Author

Hi,

Instead of using an Aggr function you can use following

sum(Total <CALLID> OpenTime)

or

You can modify your Aggr function

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

Thanks & Best Regards,

Kuldeep Tak