topic Re: How to hidden the Total Field ? in QlikView

How to hidden the Total Field ?

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

Figure 1 : Pivot Table

Figure 2 : Hidden the 3 total field

Re: How to hidden the Total Field ?

swuehl — Wed, 26 Dec 2012 15:59:53 GMT

You can check with dimensionality() function (or secondarydimensionality() for pivoted dimensions, like in your sample) if your expression is evaluated in a total context, and only execute your calculation if not):

if( secondarydimensionality() ,

YOUREXPRESSION )

Re: How to hidden the Total Field ?

Anonymous — Wed, 26 Dec 2012 22:57:24 GMT

Hi swuehl,

THKS!

expression : Target Rate % = Sum (Income)/Sum (Target)

If change to :

if( secondarydimensionality() , Sum (Income)/Sum (Target))

The Target Rate % row is null , not only total Field(right side)

Re: How to hidden the Total Field ?

Anonymous — Wed, 26 Dec 2012 22:57:46 GMT

Hi swuehl,

THKS!

expression : Target Rate % = Sum (Income)/Sum (Target)

If change to :

if( secondarydimensionality() , Sum (Income)/Sum (Target))

The Target Rate % row is null , not only total Field(right side)

Re: How to hidden the Total Field ?

swuehl — Thu, 27 Dec 2012 16:28:36 GMT

Ah, you pivoted your expressions to the left, so this seems to prevent the secondarydimensionality() function from working (like I expected).

I think you need to use dimensionality() in this case.

It is probably best if you create a new expression with just

=dimensionality()

and check the outcome. You should see different values depending on the level of hierarchy the expression is evaluated in. (I would assume something like 3, 2 and 0 in your case).

Assume your total at the right is returning a dimensionality() of 2, then you need to change your expression to

if( dimensionality() <> 2 , Sum (Income)/Sum (Target))

Hope this helps,

Stefan