Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

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 

Labels (3)
5 Replies
Highlighted
Partner
Partner

Re: aggregate sum populate every data row

Try to add 'Total' in your denominator:

sum(total aggr(sum({$}[Market Value]),[Plan Type])) 

Highlighted
Digital Support
Digital Support

Re: aggregate sum populate every data row

See duplicate post: https://community.qlik.com/t5/New-to-QlikView/aggregate-sum-populate-every-data-row/m-p/1628233#M381...

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.
New Contributor III

aggregate sum populate every data row

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

Highlighted
Digital Support
Digital Support

Re: aggregate sum populate every data row

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

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

Re: aggregate sum populate every data row

Try this

Aggr(NODISTINCT Sum([Market Value]), [Plan Type])