Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

markgraham123
Contributor II

Table chart - Accumulation

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 a11.pngny expression can be used to substitute the "Full accumulation" option in Table Chart.

Tags (1)
3 Replies
Not applicable

Re: Table chart - Accumulation

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
Contributor II

Re: Table chart - Accumulation

Hi Navdeep,

I tried the formula,

Its just hanging the Qlikview.

Not applicable

Re: Table chart - Accumulation

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

Community Browser