Applying aggr in sumif() - Qlik Community

siddharthsoam · ‎2018-09-04

I am trying the following expression

sum(if(sum(aggr(sum(EBIDTA),[Customer Group Descr]))<'0',Revenue))

but its giving me a nested aggregation not allowed error.

Can i achieve this in some other way in expression editor

kaushiknsolanki · ‎2018-09-04

Hi,

Try this.

sum(if(aggr(sum(EBIDTA),[Customer Group Descr])<'0',Revenue))

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!