Explain - The argument expression of one aggregation function must not contain another aggregation function.

[retko1985]

I found this on help - Aggregation functions ‒ QlikView

Can someone give some example?

Thank you.

[maxgro]

try to read this post

Aggregations and Function Classes

[Peter_Cammaert · Accepted solution]

It simply means that you cannot nest aggregation function calls (only one exception: if you put a call to Aggr() between them. Aggr() sort-of un-aggregates values)

For example, this is illegal syntax:

=Avg(Sum(SalesAmount))

whatever the dimensions in your table. But this isn't:

=Avg(Aggr(Sum(SalesAmount), Customer, Year))

Best,

Peter