Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
You can use RangeSum(Above(Sum(Quantity),0,RowNo())) / Sum(total Quantity) to replace full accumulation.
and for bucketing, check class() function.
I tried the formula,
Its just hanging the Qlikview.
Please attached your app or try to use it with less data.