topic Re: Explain - The argument expression of one aggregation function must not contain another aggregation function. in QlikView

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

retko1985 — Wed, 25 Nov 2020 16:16:04 GMT

I found this on help - Aggregation functions ‒ QlikView

Can someone give some example?

Thank you.

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

maxgro — Sat, 20 Jan 2018 20:17:28 GMT

try to read this post

Aggregations and Function Classes

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

Peter_Cammaert — Sat, 20 Jan 2018 20:23:52 GMT

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