Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with Aggr Function? Market Share.

I've built a pivot simialr to below and want to calcuate our share of the market.  I've ried mutiple AGGR funcitons but cant seem to crack it...so requesting some expert help

In the AGGR column, I'm expecting the Competitor total in the first 3 cells (366,496), and then the Internal products total in the following 3 (43,538).

Any help will be appreciated.

Thanks, Jay

1 Solution

Accepted Solutions
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Try Sum(TOTAL <Ownership> Sales) obviously replacing Sales with your own field.

Hope this helps,

Jason

View solution in original post

3 Replies
swuehl
MVP
MVP

If I understood correctly, try this for the share:

=sum(Amount) / sum(total<Ownership> Amount)

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Try Sum(TOTAL <Ownership> Sales) obviously replacing Sales with your own field.

Hope this helps,

Jason

Not applicable
Author

Cheers Jason - Thats exactly what I wanted.