Discussion Board for collaboration related to Creating Analytics for QlikView.
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( TOTAL <SalesRep> Calls)
qvw file attached.
Thankx in advance.
Go to Solution.
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))
gosh ! that is correct !
let me know where to send the box of chocolates :-)