Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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.

adrian_costar
Contributor III
Contributor III

:))))

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