topic Expressions in Pivot Table in QlikView

Expressions in Pivot Table

Anonymous — Mon, 05 May 2014 19:47:09 GMT

Hello,

If I have a pivot table with three dimensions and four expressions. If I collapse all of my dimensions, I still get values for my expressions for my first dimension. Is there a conditional formatting where my expressions do not reflect values if all my dimensions are collapsed?

Kind Regards,

Isabel

Re: Expressions in Pivot Table

Mon, 05 May 2014 20:06:12 GMT

Hello Isabel,

you can use Dimensionality() and SecondaryDimensionality() as conditions in your expressions.

Regards

Darek

Re: Expressions in Pivot Table

Anonymous — Tue, 06 May 2014 13:07:29 GMT

Hi Dariusz,

Thanks Dariusz, that was very helpful. Is it possible to collapse the headers for the expressions if the values for the expressions is null?

Thanks!

Kind Regards,

Isabel

Re: Expressions in Pivot Table

Tue, 06 May 2014 13:19:50 GMT

Hello,

try with "Suppress Missing", "Suppress Zero" on Presentation Tab.

regards

Darek