Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
diwakarnahata
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
PrashantSangle

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
PrashantSangle

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.
diwakarnahata
Creator
Creator
Author

Works perfectly. Thanks..