- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
aggregate sum populate every data row
need the aggr(sum() below to populate every data row in a chart to calculate [Client Rank] within [Plan Type]
numerator:
=aggr(sum({$}[Market Value]),Client,[Plan Type]); this works
denominator calculation is correct but I need it on every data row
=sum(aggr(sum({$}[Market Value]),[Plan Type])) //this is the correct
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try to add 'Total' in your denominator:
sum(total aggr(sum({$}[Market Value]),[Plan Type]))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See duplicate post: https://community.qlik.com/t5/New-to-QlikView/aggregate-sum-populate-every-data-row/m-p/1628233#M381...
Regards,
Brett
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Arthur but this returns the Grand Total on every data row.
I need the sum of Market Value Aggregated by Plan Type, on every data row.
Thanks,
Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jim, just in case Arthur is tied up, have a look at the following Design Blog post, it may help you out on this one:
https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822
Regards,
Brett
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
Aggr(NODISTINCT Sum([Market Value]), [Plan Type])