topic Re: Aggregation question in QlikView

Aggregation question

gerrycastellino — Sun, 15 Oct 2017 05:23:22 GMT

I have a multi-part aggregation that I'm doing. The last column (Tot by Agent) should be summed up by agent , and should be the same for each agent regardless of Alliance.

I've indicated what I'm expecting.

The Expression that I currently have is this:

sum(

aggr(

(

sum(Calls)

(

sum(Calls)

sum( TOTAL <SalesRep> Calls)

)

,SalesRep)

)

qvw file attached.

Thankx in advance.

Re: Aggregation question

JaMajka1 — Sun, 15 Oct 2017 07:07:16 GMT

Hello, try this one. Hope, that helps .

sum(total <SalesRep> aggr(

sum(total <Alliance,SalesRep> aggr(

sum([Calls Last]*[Calls Last])

sum(total <SalesRep> aggr(sum([Calls Last]),SalesRep)),SalesRep))

,SalesRep))

BR,

Maria

Re: Aggregation question

gerrycastellino — Sun, 15 Oct 2017 14:03:45 GMT

gosh ! that is correct !

let me know where to send the box of chocolates 🙂

Gerry.