topic Re: Aggr() Question in QlikView

Aggr() Question

Anonymous — Tue, 02 Jun 2015 11:06:00 GMT

Hi,

I'm fairly new to qlikview and struggling to implement the following chart.

I started using aggr() function hoping that would be helpful, but it doesn't give the results that I need.

This is what I'm trying to implement:

When I use =aggr(sum(Sales)/sum(TOTAL Sales),Team, TeamMember), I get this:

Any advice would be appreciated. Thanks in advance.

rubenmarin — Tue, 02 Jun 2015 15:28:42 GMT

Hi Shobana, I think you only need this:

sum(Sales)/sum(TOTAL <Team> Sales)

Anonymous — Tue, 02 Jun 2015 16:15:09 GMT

Thanks a lot Ruben, that worked!!!