Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Pb with total aggr

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

Tags (1)
2 Replies
Honored Contributor II

Re: Pb with total aggr

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

Not applicable

Re: Pb with total aggr

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


Community Browser