Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bartvanwetten
Creator
Creator

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
sunny_talwar

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
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
Creator
Creator
Author

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

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
Creator
Creator
Author

Again, you've made my day!

Thx!!