# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Contributor III

## Accumulation

Hi Expertise

first table show the sum of total products sold every week , and the second table show the accumulation of the products weeks by adding previous weeks total to current week as shown in the screenshot attached .
If you look at second table 13-jan-2019 for accumulation is not showing anything because there is no data for it .
My requirement is to show 7 products there if there is no data it should show the accumulation of previous week.

I am using the below expression to achieve the accumulation of products .

Expression:
RangeSum(before(total count({Severity={'Sev 1','Sev 2','Sev 3','Sev 4'},year={'>2018'}>}Prodcut),0, ColumnNo(total)))

4 Replies
MVP

## Re: Accumulation

Can you try this

``RangeSum(Before(TOTAL Count({<Severity = {'Sev 1','Sev 2','Sev 3','Sev 4'}, year = {'>2018'}>} Prodcut) + Sum(0), 0, ColumnNo(TOTAL)))``
MVP

## Re: Accumulation

Also, you want to see 4 or 7? The accumulation should be 4 based on 3+1+0, isn't it?

Contributor III

## Re: Accumulation

Its should be 7 and also your given expression  is not working.

`RangeSum(Before(TOTAL Count({<Severity = {'Sev 1','Sev 2','Sev 3','Sev 4'}, year = {'>2018'}>} Prodcut) + Sum(0), 0, ColumnNo(TOTAL)))`

MVP

## Re: Accumulation

What is the reason behind seeing 7 and not 4?