topic Re: Accumulation in QlikView

Accumulation

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Accumulation

sunny_talwar — Mon, 17 Jun 2019 12:57:01 GMT

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

sunny_talwar — Mon, 17 Jun 2019 12:57:52 GMT

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

Re: Accumulation

smilingjohn — Tue, 18 Jun 2019 05:07:11 GMT

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

sunny_talwar — Tue, 18 Jun 2019 11:10:13 GMT

What is the reason behind seeing 7 and not 4?