Discussion Board for collaboration related to QlikView Deployment.
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?
you can use dimensionality() check whether you're in the total line or not.
if(dimensionality() = something, something, somethingelse)
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.