topic Re: Pivot - Fabs sum in QlikView

Pivot - Fabs sum

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Pivot - Fabs sum

tresB — Thu, 28 Nov 2019 13:49:23 GMT

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

Re: Pivot - Fabs sum

danielnevitt — Thu, 28 Nov 2019 14:04:40 GMT

Thank you for the quick reply.

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

Regards,
Daniel

Re: Pivot - Fabs sum

Brett_Bleess — Tue, 10 Dec 2019 19:37:38 GMT

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