# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
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?

Bart

1 Solution

Accepted Solutions
MVP

## 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)

4 Replies
MVP

## 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)

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?

MVP

## 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)

Contributor