Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Expressions in Pivot Table

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

3 Replies
Highlighted
Not applicable

Re: Expressions in Pivot Table

Hello Isabel,

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

Regards

Darek

Highlighted
Contributor
Contributor

Re: Expressions in Pivot Table

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

Highlighted
Not applicable

Re: Expressions in Pivot Table

Hello,

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

regards

Darek