topic Cumulative % in QlikView

Cumulative %

johnhorneramllp — Thu, 10 Jun 2010 03:15:25 GMT

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

Cumulative %

johnhorneramllp — Thu, 10 Jun 2010 03:18:29 GMT

please see attachment.

Cumulative %

johnhorneramllp — Thu, 10 Jun 2010 03:21:10 GMT

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

Cumulative %

Anonymous — Thu, 10 Jun 2010 03:59:17 GMT

:))))

Cumulative %

johnhorneramllp — Thu, 10 Jun 2010 16:08:27 GMT

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

Cumulative %

Thu, 10 Jun 2010 19:59:33 GMT

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