topic Re: aggregate sum populate every data row in QlikView

aggregate sum populate every data row

wynnjimbbt — Sat, 16 Nov 2024 20:00:55 GMT

need an aggr(sum() below to populate every data row in a chart

calculating [Client Rank] within [Plan Type]

aggr(sum({$}[Market Value]),Client,[Plan Type]); this works for my numerator

=sum(aggr(sum({$}[Market Value]),[Plan Type])) //this is the correct denominator but I need it on every data row

Re: aggregate sum populate every data row

Brett_Bleess — Mon, 07 Oct 2019 18:45:04 GMT

Jim, sorry I am not much help here, posting a link from the Design Blog area on pitfalls related to AGGR for you to check, but there are quite a few other posts on AGGR there as well, just not sure if any of those will help or not, so going to let you search those yourself with the second link, which is the main page where there is a search dialog, just search on AGGR to see the hits.

https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

My post will also kick this back up in the list again, so someone else may see things and have something better to offer too.

Regards,
Brett

Re: aggregate sum populate every data row

Brett_Bleess — Mon, 07 Oct 2019 18:48:14 GMT

See duplicate post: https://community.qlik.com/t5/QlikView-App-Development/aggregate-sum-populate-every-data-row/m-p/1628351/highlight/false#M446261

Regards,
Brett