Aggregation

[PKPK90]

HI, I am new in QlikCloud, I would like to create a measure that will aggregate percentage value from previous rows to have something like running sum, the goal is to create ABC analysis.

This is how I started, I failed in measure nr.3, it is not aggregating and remove sorting.

1. Total Revenue $ = Sum([Total Revenue $])

2. Total% = Sum([Total Revenue $])/Sum(TOTAL [Total Revenue $])

3. Aggr = RangeSum(Above(
Aggr(
Sum([Total Revenue $]) / Sum(TOTAL [Total Revenue $]),
Material
),
0,
RowNo(TOTAL)
))

[Or · Accepted solution]

This was written for QV, but the same applies to QS:

https://community.qlik.com/t5/Design/Recipe-for-an-ABC-Analysis/ba-p/1472867

[PKPK90]

Thank you, that really helps.