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

Ignore Dimension in calculation Pivot table

Want to calculate market share in Pivot table for the below data,

In pivot table I have done cross tabulation with brand and below that I have market share, I want to get sum of brands in calculation ignoring the cross tabulation in Pivot table.

 

Brand 1Brand 2 Brand 3Brand 4
Market ShareMarket ShareMarket ShareMarket Share
Region 165979396
Region 269806954
Region 367926959
Region 493688188
Region 593858792
Region 682899161
1 Solution

Accepted Solutions
swuehl
MVP
MVP

Have you tried applying the principles of the TOTAL qualifier to your setting?

What about an expression like

=Sum(TOTAL<Region> Amount)

(Replace Amount with the field you are using in your current expression).

Does it return 351 for Region1 in each column?

If not,please post a complete description of your chart, all dimensions used, all expressions used.

View solution in original post

5 Replies
swuehl
MVP
MVP

If you want to ignore the dimensions in a table chart, you can use the TOTAL qualifier, also possible adding a field list to only consider specific dimensions:

Sum( Amount)

will consider all dimensions

Sum(TOTAL Amount)

will consider no dimensions (evaluation in total context)

Sum(TOTAL<Region> Amount)

will consider only Region dimension

The Aggregation Scope

Not applicable
Author

Does not solve my problem.

Output should be

(Region 1, Brand 1) that is 65 divided by sum of (Region1 and Brand 1,2,....) that is 65+97+93+96

65 divided by 351

sunny_talwar

May be like this (assuming Sum(Sales) is your original expression):

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

swuehl
MVP
MVP

Have you tried applying the principles of the TOTAL qualifier to your setting?

What about an expression like

=Sum(TOTAL<Region> Amount)

(Replace Amount with the field you are using in your current expression).

Does it return 351 for Region1 in each column?

If not,please post a complete description of your chart, all dimensions used, all expressions used.

sunny_talwar

Here is a sample attached

Capture.PNG

Clearly shows the expression which Stefan has tried to explain you. See if this is what you want or not