Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
shobanaps
New Contributor

Aggr() Question

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:

Req.png

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

Qlik.png

Any advice would be appreciated. Thanks in advance.

1 Solution

Accepted Solutions

Re: Aggr() Question

Hi Shobana, I think you only need this:

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

2 Replies

Re: Aggr() Question

Hi Shobana, I think you only need this:

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

shobanaps
New Contributor

Re: Aggr() Question

Thanks a lot Ruben, that worked!!!

Community Browser