Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
johnhorneramllp
Contributor III
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
Contributor III
Contributor III
Author

please see attachment.

johnhorneramllp
Contributor III
Contributor III
Author

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

adrian_costar
Contributor III
Contributor III

:))))

johnhorneramllp
Contributor III
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