Discussion Board for collaboration related to Creating Analytics for QlikView.
i'm looking for a solution to this problem.
Let say i've a formula like GTP = (A * B - C ) -D where A,B,C,D are expressions using sum(aggr(sum( ))).
It works perfectly for every line and total but there is a special rule for GTP total which has to be like sum(GTP).
here is a sample.
I will appriciate every clue because i tried i think almost everything (dimensionality, above(aggr....)
Sorry, I don't understand the problem. What Expression is returning the wrong value? what value are you expecting to get?
in the pivot table there is a column named GTP.
This column gets a result from other columns which is correct for every line but for the GTP total i need sum(GTP) and i can't work it out.
I hope this is more clear