topic Re: Accumulative Field in QlikView

Accumulative Field

ecabanas — Thu, 28 Jan 2016 15:13:45 GMT

Hi all,

I have a table with the number of lines of each product. = Count(line) Dimension ItemId

I wanna know the accumulative number of lines in number and %

Any suggestion?

Many thanks

sunny_talwar — Thu, 28 Jan 2016 15:16:49 GMT

For Accumulation try using Full Accumulation option within the expressions tab:

For % Accumulation try full accumulation + Relative checked on expression tab:

ecabanas — Thu, 28 Jan 2016 15:22:56 GMT

Hi Sunny

I already tryied this but did not work

sunny_talwar — Thu, 28 Jan 2016 15:24:35 GMT

Would you be able to share a sample?

ecabanas — Thu, 28 Jan 2016 15:30:12 GMT

Here it is

Many thank's

sunny_talwar — Thu, 28 Jan 2016 15:35:46 GMT

Ended up using expressions to do the accumulation

1) RangeSum(Above(TOTAL Count(SalesId), 0, RowNo(TOTAL)))

2) RangeSum(Above(TOTAL Count(SalesId), 0, RowNo(TOTAL)))/Sum(TOTAL Aggr(Count(SalesId), ItemId, name))

ecabanas — Thu, 28 Jan 2016 16:44:21 GMT

WOWWWWWW

Bravo!!!

Many many thank's