Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to make Qlik Sense pivot table aggregate the totals for percentages.

Currently my pivot table sums the total for each customer entry. This works fine for financial values, but not for percentage based formulas.

Capture.PNG

Note in the screenshot above that it has simply added 4.75%, 6.5% and 4.75% together giving a total of 16%. But if we were to sum those lines together we would get closer to 12.5%.

The formula used is =sum(LAP_TGT_Rc/RET_TOT)

How do I make the totals for each customer reflect the sum of the whole for that customer, as opposed to Qlik just adding up each subline for said customer and spitting out a total?

1 Solution

Accepted Solutions
rodjager
Partner - Creator
Partner - Creator

Hi David,

Have you tried breaking the expression into two sums eg make the formula:

=sum(LAP_TGT_Rc) / sum(RET_TOT)


Hope this helps.


Rod

View solution in original post

2 Replies
rodjager
Partner - Creator
Partner - Creator

Hi David,

Have you tried breaking the expression into two sums eg make the formula:

=sum(LAP_TGT_Rc) / sum(RET_TOT)


Hope this helps.


Rod

Anonymous
Not applicable
Author

Would never have guessed that it'd be something so simple, thank you.