Cumulative total after selection straight table

[bartvanwetten]

Hi all, can someone help me out on this one:

On the cumulative balance (straight table, set cumulative) in the attached qlikview file the amount is correct as long as I select a period starting with the very first.

So if I select 2016,2017,2018 and the first f.e. 5 months of 2018, the balance at the end is correct.

But what I want is when i select just 2018, it shows me 2018 only and still the right amount, so, everything before 2018 and the rest.

Can you help me?

Great thanks in advance!

Bart

[sunny_talwar]

Try this expression without 'No Accumulation' selected

RangeSum(Above(

Sum({<TAB={'BALANS'}, Subverdichting={'ANLAGEVERMÖGEN'}, Hoofdverdichting={'BODEN'}, Type={'Resultaat'}, Year, YearMonth, Month, Quarter, QuarterYear, Day>} amount), 0, RowNo()))

* Avg({<TAB={'BALANS'}, Subverdichting={'ANLAGEVERMÖGEN'}, Hoofdverdichting={'BODEN'}, Type={'Resultaat'}>} 1)

[bartvanwetten]

Hey Sunny,

Works again! But now, If f.e. in may 2018 there are no mutations it shows nothing (NULL) for that month. It should than shows the month before (as if it were cumulative).

Any idea?

[sunny_talwar · Accepted solution]

Try this

RangeSum(Above(RangeSum(Sum({<TAB={'BALANS'}, Subverdichting={'ANLAGEVERMÖGEN'}, Hoofdverdichting={'BODEN'}, Type={'Resultaat'}, Year, YearMonth, Month, Quarter, QuarterYear, Day>} amount), Sum({1} 0)), 0, RowNo())) * Avg(1)

[bartvanwetten]

Again, you've made my day!

Thx!!