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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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