Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
johnhorneramllp
Partner - Contributor III
Partner - Contributor III

Cumulative %

I have what appears to be a simple need to calculate a %age on some cumulative numbers but the % is not being calculated on the runningsum numbers. I am sure i am missing something obvious, any thoughts on how i can get this done, i have attached a small test dataset to highlight the problem, though my real dataset is larger and more complex.

Cheers

John H

5 Replies
johnhorneramllp
Partner - Contributor III
Partner - Contributor III
Author

please see attachment.

johnhorneramllp
Partner - Contributor III
Partner - Contributor III
Author

ok the attachment is not loading...will keep trying.

Anonymous
Not applicable

:))))

johnhorneramllp
Partner - Contributor III
Partner - Contributor III
Author

ok let's try again with the attachment...

Not applicable

Hi,

First your % (Accum) expression is the same as the % expression. I guess that was a typo? That does not appear to be the problem. I tried a "roll your own" accumulation and it appears to work. You are expecting to see 40% for the "B", correct?

sum(Metric1) + if(Above(Z1),Above(Z1),0)

sum(Metric1) + if(Above(Z2),Above(Z2),0)

[Z1] / [Z2]

HTH,

David