Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
wynnjimbbt
New Contributor III

aggregate sum populate every data row

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

 

Labels (3)
2 Replies
Support
Support

Re: aggregate sum populate 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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Support
Support

Re: aggregate sum populate every data row

See duplicate post: https://community.qlik.com/t5/QlikView-App-Development/aggregate-sum-populate-every-data-row/m-p/162...

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.