topic Re: Nested Aggr() in QlikView

Nested Aggr()

rutger_jansen — Sat, 16 Nov 2024 02:46:01 GMT

Hi,

I'm trying to get the sum of weighted scores within a dimension's class using nested Aggr(). The attached example should clarify what I'm trying to achieve and what I've tried. The real version has some set analysis as well but I don't expect that will make a difference.

Thanks,

Rutger

Re: Nested Aggr()

sunny_talwar — Mon, 12 Aug 2019 13:02:59 GMT

Try this

Aggr(NODISTINCT Sum(Aggr( Sum(sales)/Sum(TOTAL <vehicle> sales) * score , vehicle, engine)) , vehicle)

Re: Nested Aggr()

rutger_jansen — Mon, 12 Aug 2019 13:32:11 GMT

Thanks very much Sunny.