topic Re: Undesired total in pivot table in QlikView

Undesired total in pivot table

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hallo,

I'vo got a pivot table with a code in DIMENSION, and quantity, unit cost and unit cost*quantity in EXPRESSION.

For each code, I'd like to obtain the total of quantity and cost*quantity BUT NOT the total of unit cost (because it's senseless, obviously), but the option "Total mode" in not available.

Could someone help me, please?

Thks,

Re: Undesired total in pivot table

sunny_talwar — Wed, 01 Mar 2017 11:03:36 GMT

Pivot table doesn't have a total mode option, but you should be able to replicate what you need using Sum(Aggr(...)) function. In your case you might just need to add Sum() outside cost*quantity if they are field names

Sum(cost*quantity)

Sum(Aggr(cost*quantity, <YourChartDimensions>))

Re: Undesired total in pivot table

Anonymous — Wed, 01 Mar 2017 12:40:06 GMT

Thank you for the replay; maybe I didn't explain the problem very well: the pivot table shows the sum of the unit costs (as well as the other two fields) but I don't want it to show.

Thanks.

Re: Undesired total in pivot table

sunny_talwar — Wed, 01 Mar 2017 12:46:18 GMT

May be use Dimensionality() and/or secondaryDimensionality() to hide the totals. Something along these lines:

If(Dimensionality() = 0, Null(), YourExpression)

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()