Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

% Contribution in pivot table

Hi,

I have a pivot table with 2 dimensions and 1 expression. Here in the expression i want to show the % contribution of the second dimension. I tried using partial sums on second dimension, but couldn't put that in the denominator of the expression to show its contribution. Is there any way we can implement this?

Regards,

Diwakar

1 Solution

Accepted Solutions
Highlighted

Hi,

use Total in your expression

for calculating %

Your Expression Like

yourExpression/Sum(Total<2nd DimensionName>Sales)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

2 Replies
Highlighted

Hi,

use Total in your expression

for calculating %

Your Expression Like

yourExpression/Sum(Total<2nd DimensionName>Sales)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

Creator
Creator

Works perfectly. Thanks..