Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Aggr

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

2 Replies
danielrozental
Honored Contributor II

Re: Aggr

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

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

Not applicable

Re: Aggr

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