topic Re: How to make Qlik Sense pivot table aggregate the totals for percentages. in App Development

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

Anonymous — Tue, 29 May 2018 09:05:54 GMT

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

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?

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

rodjager — Tue, 29 May 2018 09:40:08 GMT

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

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

Anonymous — Tue, 29 May 2018 10:17:26 GMT

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