Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
The expression same can be:
=if(Customer<>'David',Customer)
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())
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. 😕
If you want to hide the dimension but keep the pivot table hierarchy, you can set the expression for dimension and keep Null values.
The expression same can be:
=if(Customer<>'David',Customer)