topic Re: Accumulation - include first row in totals in QlikView

Accumulation - include first row in totals

Wed, 11 Mar 2015 20:38:37 GMT

Hi,

I'm having an issue with my accumulation function. I need it to include the value on the first row as well. Below is the output I am currently experiencing, however what I was expecting to see is in the "Running Total" column - 75.73% on the first row and the subsequent values adding on top of the initial value. Any assistance would be greatly appreciated.

Here is how the columns are being calculated:

Relative Total: sum(count) WITH relative option selected

Total Count: sum(count) WITHOUT relative option selected

Running Total: Above(TOTAL Column(1)) + If(Above(TOTAL Column(3)) > 0, Above(TOTAL Column(3)), 0)

Re: Accumulation - include first row in totals

robert_mika — Wed, 11 Mar 2015 20:56:54 GMT

Does this help:

if(rowno()=1,sum([Relative Total]),RangeSum (above(sum([Relative Total]),0,RowNo())))

This

is different data set but as you see is working

Re: Accumulation - include first row in totals

Wed, 11 Mar 2015 21:03:29 GMT

Hi Robert,

Thank you for your reply but using your solution fills all of the rows with 0%

Re: Accumulation - include first row in totals

robert_mika — Wed, 11 Mar 2015 21:09:45 GMT

I'm at home using PE so I can not ask for qvw file unless you can wait till tomorrow when I at work.

But if you can post sample of your data I can look at this again

Re: Accumulation - include first row in totals

Wed, 11 Mar 2015 21:24:02 GMT

Here is a .csv of the raw data. In the table i'm rolling the data up to Month-Year

Re: Accumulation - include first row in totals

ramoncova06 — Thu, 12 Mar 2015 00:40:52 GMT

This works for me

if(RowNo(total) = 1,column(1)/sum(total cnt),

rangesum(column(1)/sum(total cnt),Above(total [Running Total]))

)

Re: Accumulation - include first row in totals

Thu, 12 Mar 2015 02:14:03 GMT

Thank you for the reply Ramon. Unfortunately using your solution is not accumulating the relative percentage.Is there any other options i need enabled?

Re: Accumulation - include first row in totals

anbu1984 — Thu, 12 Mar 2015 02:42:11 GMT

Running Total: Alt(Above( Column(3)),0)+Sum(cnt)

Running Total %: Column(3)/ Sum(TOTAL cnt)*100