topic Re: aggregate sum populate every data row in QlikView

aggregate sum populate every data row

wynnjimbbt — Sat, 16 Nov 2024 20:00:52 GMT

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

Arthur_Fong — Thu, 26 Sep 2019 00:16:09 GMT

Try to add 'Total' in your denominator:

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

Brett_Bleess — Mon, 07 Oct 2019 18:47:44 GMT

Regards,
Brett

wynnjimbbt — Mon, 09 Dec 2019 16:47:41 GMT

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

Brett_Bleess — Mon, 09 Dec 2019 16:56:28 GMT

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:

Regards,
Brett

sunny_talwar — Mon, 09 Dec 2019 17:25:53 GMT

Try this

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