topic Wrong total with Aggr in QlikView

Wrong total with Aggr

Thu, 28 Feb 2013 09:40:14 GMT

Hi everybody,

I'm using sum(aggr(sum(field))) in 4 expressions. It works perfectly for every line and total.

But I've another expr T which uses the 4 expressions like (A * B - C) * D

So T is correct for every line but for the total *I would like T equals some of evryline and I can't refer to expression.

Thank you for your help

Chris

Gysbert_Wassenaar — Thu, 28 Feb 2013 09:42:21 GMT

If you're using a straight table you change the Total Mode of the expression from Expression Total to Sum of Rows.

Thu, 28 Feb 2013 10:16:23 GMT

Hi Gysbert,

unfortunately i'm using a pivot table.

And , before you ask, use of dimensionality() has no effect because my pb is to use the right formula

Chris