topic Re: Cumulative total after selection straight table in QlikView

Cumulative total after selection straight table

bartvanwetten — Tue, 06 Nov 2018 19:26:16 GMT

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

Re: Cumulative total after selection straight table

sunny_talwar — Tue, 06 Nov 2018 19:41:17 GMT

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)

Re: Cumulative total after selection straight table

bartvanwetten — Tue, 06 Nov 2018 20:14:24 GMT

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?

Re: Cumulative total after selection straight table

sunny_talwar — Tue, 06 Nov 2018 20:30:17 GMT

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)

Re: Cumulative total after selection straight table

bartvanwetten — Tue, 06 Nov 2018 21:33:23 GMT

Again, you've made my day!

Thx!!