topic Re: Calculate Running balance in QlikView

Calculate Running balance

Fri, 24 Apr 2015 09:16:09 GMT

Hi,

I am struggling to work out how to calculate a running balance in a chart.

I want an expression that takes a figure from the total and then each row continues to calculate this as we move down the chart.

PFA a dummy target answer

Thanks

Stuart

anbu1984 — Fri, 24 Apr 2015 09:30:02 GMT

Check this app

ankitaag — Fri, 24 Apr 2015 09:42:24 GMT

Hello Stuart,

Save the sum(Effect Count) in a variable

in the expressio tab write the 1st expression as effect count and check the full accumulation box below.

2nd expression as variable-column(1)

Go to the poresentation tab and check the hide column option for the 1st expression.

awhitfield — Fri, 24 Apr 2015 09:43:35 GMT

Hi Stuart,

see the attached, expression used is

[RunningBalance]-RangeSum(above(Sum(EffectCount),0,RowNo()))

Hope it helps!

Andy

Fri, 24 Apr 2015 10:05:41 GMT

thanks