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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
ColtE8
Contributor III
Contributor III

Percentages greater than 100%

Hello everyone,

In my pivot table I have specific amounts that can be selected between two binary buttons, one for amount and one for absolute amount. The amounts are located in a pivot table which switches between the two types of amounts based on the button selected. That's what the vAmountType2 variable is for. In my percentage of amount column, I have an expression of:

if(vAmountType2 = 1, (Sum(amount) / Sum(TOTAL amount)), (Sum(absamount) / Sum(TOTAL absamount)))

Some of the percentages coming up are 150% or 200% and obviously that doesn't make any sense. What am I missing?

Thanks,

Colton Esman
https://www.linkedin.com/in/colton-esman/
0 Replies