Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
See duplicate post: https://community.qlik.com/t5/QlikView-App-Development/aggregate-sum-populate-every-data-row/m-p/162...
Regards,
Brett