If you are trying to achieve this in a QlikView straight table, then you will have the option to change your expression totaling from the default expression totaling to sum og rows. I believe that totaling method will help you to get rid of the aggr() in your expression.