Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subtotal % Problem

I want this pivot table but I don't know how to build the last formula, as "sum(Qt) / sum(TOTAL)". How do I do?

StoreProductQt%
AX250%
AZ250%
ATotal4100%
BX229%
BZ571%
BTotal7100%
3 Replies
Not applicable
Author

Try this:

Sum(Qt) / Sum(TOTAL Qt)

Not applicable
Author

Yeh, we already tried it, but the value in percentage appears as TOTAL of  sum of stores, for example, in the table, to the first line appears as 18% (2/11) and not 50% (2/4).

Any other idea?

Not applicable
Author

Aha, then you want this:

Sum(Qt) / Sum(TOTAL<Store> Qt)