topic Accumulating % in a column calculation in QlikView

Accumulating % in a column calculation

Tue, 15 Oct 2013 07:20:34 GMT

hi in the following example i have the following;

the percentage should be accumulating so for example it starts at 7 but the next steps should be 0,32% instead of 57% and so forth.

my calculation is as follows column (11) / Column (12) and set to percent.

any help would be greatly appreciated.

Best Brad

CELAMBARASAN — Tue, 15 Oct 2013 07:53:55 GMT

Hi,

You need to create a hidden expression for this

Doi Ack Accumulation = Alt(Above([Doi Ack Accumulation]), 0) + [Doi Ack]

Doi ack Plan Accumulation = Alt(Above([Doi ack Plan Accumulation]), 0) + [Doi ack Plan]

Index Per Day will be [Doi Ack Accumulation] / [Doi ack Plan Accumulation]

Tue, 15 Oct 2013 08:14:47 GMT

thank you for your advise!

i have attached my document to explain the issue further.

i could not follow the logic you provided as i had false refernces to the dimensions *.. Accumulation....*

thank you in advance.

Brad