topic Re: Pb with total aggr in QlikView

Pb with total aggr

Thu, 07 Mar 2013 13:54:39 GMT

Hi everybody,

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....)

danielrozental — Thu, 07 Mar 2013 16:56:51 GMT

Sorry, I don't understand the problem. What Expression is returning the wrong value? what value are you expecting to get?

Fri, 08 Mar 2013 14:21:42 GMT

Hi Daniel

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

best regards

christian