topic Re: total in pivot in QlikView

total in pivot

andyrebs — Fri, 26 Oct 2012 09:16:32 GMT

Hi,

as you can see in the below image, the total in the last column is calulculated by 161*114, not by the sum of 5.459+3.679.

How I can set partial sum as I want?

Many thanks

Andrea

jonathandienst — Fri, 26 Oct 2012 09:29:42 GMT

You will need to use an Aggr() expression for your table. It will look something like:

=Sum(Aggr( ... your current calculation here ... , Dim1, Dim2, Dim3, ...)

For example

=Sum(Aggr(Sum(Amount * Factor), ClientID))

Insert your current expression in ... your current calculation here ... and the pivot table dimensions in Dim1, Dim2, etc.

Hope that helps

Jonathan

andyrebs — Fri, 26 Oct 2012 09:49:16 GMT

Hi Jonathan,

thanks for your answer.

The expressions in the table are:

Q.tà: sum({$<Importo-={''}>} [Q.tà ord.])

Ultimo costo: sum([cost])

costo totale: =num(sum([cost])*sum({$<Importo-={''}>} [Q.tà ord.]))

If I set the last expression as you suggest

sum (aggr (sum([cost])*sum({$<Importo-={''}>} [Q.tà ord.]) ) [Codice articolo]))

it returns an error.

jonathandienst — Fri, 26 Oct 2012 12:08:40 GMT

Assuming [Codice articolo] is the only dimension on the pivot table:

Sum(Aggr(Sum([cost]) * sum({$<Importo-={''}>} [Q.tà ord.]), [Codice articolo]))

You have typed a ) where there should be comma. If there are other dimensions, add them after [Codice articolo] as a comma separated list.

Regards

Jonathan

andyrebs — Fri, 26 Oct 2012 12:22:30 GMT

Many thanks Jonahtan!