Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

gerrycastellino
Contributor III

Aggregation question

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.

Sum by agent.PNG

1 Solution

Accepted Solutions
jamajka1
Contributor

Re: Aggregation question

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

2 Replies
jamajka1
Contributor

Re: Aggregation question

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

gerrycastellino
Contributor III

Re: Aggregation question

gosh !  that is correct !

let me know where to send the box of chocolates :-)

Gerry.

Community Browser