Table chart - Accumulation

[markgraham123]

Hi,

I accumulated the relative values.

now, i wanna separate the accumulated values into buckets.

0-25%, 26-50%, 51-75%, and 76-100%.

I tried this, RangeSum(Above(Sum(Relative), 0, RowNo())) but no result.

Please let me know if any expression can be used to substitute the "Full accumulation" option in Table Chart.

[#2]

Hi,

You can use RangeSum(Above(Sum(Quantity),0,RowNo())) / Sum(total Quantity) to replace full accumulation.

and for bucketing, check class() function.

Regards,
Navdeep

[markgraham123]

Hi Navdeep,

I tried the formula,

Its just hanging the Qlikview.

[#4]

Please attached your app or try to use it with less data.