topic Re: How to hide dimention in Pivot Table in Connectivity & Data Prep

How to hide dimention in Pivot Table

Manlyhero — Mon, 21 Mar 2022 15:47:47 GMT

Hi all,

I am very new on qlik sense and my problem is I want to hide dimension from the pivot table but also want to keep one to many relations as showned in the image. Is there a way to do that?

Re: How to hide dimention in Pivot Table

Lisa_Sun — Thu, 24 Mar 2022 01:50:50 GMT

On the chart property, select the dimension which you want to hide. Under "Text color expression", set this expression to make the text color to white.

if([Field name]>0, white())

Re: How to hide dimention in Pivot Table

Lisa_Sun — Thu, 24 Mar 2022 01:52:34 GMT

Re: How to hide dimention in Pivot Table

Manlyhero — Thu, 24 Mar 2022 06:52:57 GMT

Thank you for you response but is there any alternative to completely disappear that column? Like dimension exist but in the background etc? Because in that case report will be like this

Also If I want to export the report as an excel field will appear as it is. 😕

Re: How to hide dimention in Pivot Table

Lisa_Sun — Mon, 28 Mar 2022 00:34:07 GMT

If you want to hide the dimension but keep the pivot table hierarchy, you can set the expression for dimension and keep Null values.

Re: How to hide dimention in Pivot Table

Lisa_Sun — Mon, 28 Mar 2022 00:34:59 GMT

The expression same can be:

=if(Customer<>'David',Customer)