# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Contributor

## Accumulation with Rangesum and multiple dimensions

I am trying to create an accumulation of values('Days') based on multiple dimensions(ProductId & Phase).

I have discounted the Chart Accumulation method and tried the 'rangesum(above(sum(x), expr2))' expression method but not got it working. What is the correct expression per this example?

The second issue centers on blank field dates. In the script I can create an IF with peek function but where there blanks for two or more fields etc what is the best solution? I assume it is a loop in the script. In the attached qvw example how would it work?

Simon

1 Solution

Accepted Solutions
MVP

## Re: Accumulation with Rangesum and multiple dimensions

Try this:

=Rangesum(Above(sum(Days), 0, RowNo()))

5 Replies
MVP

## Re: Accumulation with Rangesum and multiple dimensions

What is the expected output here? Can you elaborate?

Highlighted
Contributor

## Re: Accumulation with Rangesum and multiple dimensions

Hi Sunny

Below is an expected output for CumDays for issue 1 and ExpectedDate for issue 2.

 OrderId ProductId Phase Days CumDays ExpectedDate AA101042016 1 1 3 3 03/03/2016 AA101042016 1 2 2 5 05/03/2016 AA101042016 1 3 4 9 10/03/2016 AA201042016 2 1 4 4 16/04/2016 AA201042016 2 2 2 6 16/04/2016 AA201042016 2 3 1 7 17/04/2016 AA201042016 2 4 3 10 17/04/2016 BB110042016 3 1 3 3 13/04/2016 BB110042016 3 2 1 4 13/04/2016 BB110042016 3 3 1 5 13/04/2016 BB110042016 3 4 1 6 15/04/2016 BB110042016 3 5 2 8 19/04/2016

Thanks

Simon

MVP

## Re: Accumulation with Rangesum and multiple dimensions

Try this:

=Rangesum(Above(sum(Days), 0, RowNo()))

MVP

## Re: Accumulation with Rangesum and multiple dimensions

For the ExpectedDate requirement, you can try this:

=Date(If(Len(Trim(AllCompletedDate)) > 0, AllCompletedDate, Above([Exp Label])))

But this might not look good when you make selections because it is self referencing itself.

Contributor

## Re: Accumulation with Rangesum and multiple dimensions

I now understand my error re:rangesum and dimensions. I will test this solution with an actual large dataset.

As for your ExpectedDate solution I look into this further. As you said it is self referencing.

Thanks

Simon