topic Re: Table chart - Accumulation in QlikView

Table chart - Accumulation

markgraham123 — Thu, 11 Jun 2015 23:22:11 GMT

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.

Fri, 12 Jun 2015 04:47:56 GMT

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 — Fri, 12 Jun 2015 13:04:48 GMT

Hi Navdeep,

I tried the formula,

Its just hanging the Qlikview.

Sat, 13 Jun 2015 11:08:24 GMT

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