Aggregation

PKPK90 — Wed, 14 May 2025 10:28:07 GMT

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)
))

Re: Aggregation

Or — Wed, 14 May 2025 12:41:19 GMT

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

Re: Aggregation

PKPK90 — Fri, 16 May 2025 14:29:11 GMT

Thank you, that really helps.

topic Re: Aggregation in App Development

Aggregation

Re: Aggregation

Re: Aggregation