topic Re: Help with Aggr() function in QlikView

Help with Aggr() function

sangeess21 — Wed, 25 Nov 2020 16:16:04 GMT

I have an expression using aggr() that I'm struggling with. I'm trying to show Extended Avg Selling Price (Quantity* Avg Selling Price) for CM supplier using a Pivot table. But the total value is not being summed up correctly.

The expression I've used is

if(Match(Dimensionality( ),0,1,2), sum(aggr(sum(Quantity)*[Avg Selling Price],[Purchase Order])), sum(Quantity)*[Avg Selling Price])

I appreciate any help... Thanks!

Re: Help with Aggr() function

MK_QSL — Fri, 27 Jul 2018 21:02:46 GMT

Try

SUM(Quantity * [Avg Selling Price])

instead of

sum(Quantity)*[Avg Selling Price])

Re: Help with Aggr() function

BalaBhaskar_Qlik — Sat, 28 Jul 2018 10:30:46 GMT

May be:

if(Match(Dimensionality( ),0,1,2), sum(aggr(sum(Quantity)*Only([Avg Selling Price]),[Purchase Order])), sum(Quantity)*Only([Avg Selling Price]))

Re: Help with Aggr() function

sangeess21 — Fri, 03 Aug 2018 19:53:12 GMT

Thank you. It's working as expected.