Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sales shares in Pivot

I have a pivot table in which there are calculated sales of agents by brands and I want to calculate sales share of brands in total agent sales.

1 Solution

Accepted Solutions
sunny_talwar

May be like this:

Dimension:

Agents

Brands

Expression:

Sum(Sales)/Sum(TOTAL <Agents> Sales)

View solution in original post

3 Replies
oknotsen
Master III
Master III

Are you using QlikView or Qlik Sense?

Based on that answer, we will move this question to the right section of the community.

Edit:

Question is ignored, so moving topic to QlikView section.

May you live in interesting times!
sunny_talwar

May be like this:

Dimension:

Agents

Brands

Expression:

Sum(Sales)/Sum(TOTAL <Agents> Sales)

View solution in original post

Not applicable
Author

It works

Thank you a lot