Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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