Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Digital Support
Digital Support

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.
Highlighted
Digital Support
Digital Support

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.