Skip to main content

# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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 1 Brand 2 Brand 3 Brand 4 Market Share Market Share Market Share Market Share Region 1 65 97 93 96 Region 2 69 80 69 54 Region 3 67 92 69 59 Region 4 93 68 81 88 Region 5 93 85 87 92 Region 6 82 89 91 61
1 Solution

Accepted Solutions
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.

5 Replies
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

MVP

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

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

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.

MVP

Here is a sample attached

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

Community Browser