Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
smilingjohn
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 not getting this can you expertise please help with this .

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

Thanks in Advance 

4 Replies

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

Re: Accumulation

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

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

 

Re: Accumulation

What is the reason behind seeing 7 and not 4?