topic Re: Aggr in QlikView

Aggr

Mon, 26 Jan 2026 18:19:17 GMT

Hi everybody,

I'm using sum(aggr(sum(....))) for some expression in a pivot table.

One of the expression (GTP) is ([expr A] - sum(B))

Note Expr A uses already 3 others expressions that use sum(aggr(sum( )))

GTP is ok for everyline and the total use the same formula.

But for the total I just want a sum(GTP) and obviously i can't refer to [GTP] and the use of aggregate doesn't work. (I mean i didn't find the right solution).

Does anyone have a clue?

best regards

chris

Re: Aggr

danielrozental — Fri, 22 Feb 2013 16:23:45 GMT

you can use dimensionality() check whether you're in the total line or not.

if(dimensionality() = something, something, somethingelse)

Re: Aggr

Fri, 22 Feb 2013 16:32:51 GMT

No i tried that already but i can't refer to [GTP] name of field and other expressions in use can't be sum.

Only the result of all aggregated lines must be a sum at the total.

Christian