Cumulating first column of balance with prior months

[bartvanwetten]

Dear,

attached you'll find a qlikview document with a balance in a chart. The dimension is year and month, The expression is cumulative.

Now if I select a period 2013/01 to 2013/07 the expression total is correct (82.308) and the cumulitive months also.

Now I select a period f.e. 2013/03 to 2013/07 the first column 2013/03 should be the sum of the first 3 months and the result at the end should be 82.308 again.

Can anybody help me out on how to create the correct expression for this?

Thx!!

Bart

[annafuksa1]

I will strongly recomennent you to change data model

for Periode 2013/01 Periode_only has 2 valous 00 and 01 you should change it or create pne more fiield that will have only value 01

I have uploaded app with kind of solution for your problem

Anna

[bartvanwetten · Accepted solution]

Thanks Anna,

used your solution!

Bart