Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT 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..