Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
bartvanwetten
Contributor

Cumulative total after selection straight table

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

1 Solution

Accepted Solutions

Re: Cumulative total after selection straight table

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)

View solution in original post

4 Replies

Re: Cumulative total after selection straight table

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
Contributor

Re: Cumulative total after selection straight table

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

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)

View solution in original post

bartvanwetten
Contributor

Re: Cumulative total after selection straight table

Again, you've made my day!

Thx!!