Pivot - Fabs sum - Qlik Community

danielnevitt · ‎2019-11-28

Hi,

I am trying to create an expression in a pivot table that calculates the Fabs Sum where the exchange_cd = 'ICE'. The below expression has returned an error and I would appreciate some help.

Sum(aggr(fabs(sum({<exchange_cd={'ICE'}>}pos_vol))

Thanks
Daniel

tresesco · ‎2019-11-28

Sum(aggr(fabs(sum({<exchange_cd={'ICE'}>}pos_vol)), <dimension for aggr>))

danielnevitt · ‎2019-11-28

Thank you for the quick reply.

Please can you explain what is meant by dimension for aggr?

Regards,
Daniel

Brett_Bleess · ‎2019-12-10

Have a look at the following Design Blog post, I think that should help you with things:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.