Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wynnjimbbt
Contributor III
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
Brett_Bleess
Former Employee
Former Employee

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 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.
Brett_Bleess
Former Employee
Former Employee

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 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.