Discussion board where members can get started with QlikView.
I am having a pivot table as below:
I want to hide the expression used in the the table.
I have tried with the straight table but it is showing the duplicating the name for 'N' number times.
Can anyone help in this!?
Yoganantha Prakash G P
if you want to use a pivot table only to show the data then no need to an expression, just uncheck suppress zero values in presentation tab
View solution in original post
If you want to disable expression - just uncheck the Enabled option in Expression tab.
If you want to hide it - go to the background color of it expression and set ARGB(0,0,0,0) - it will make all values invisible.
another way of hiding the expression in Pivot table would be to put a condition like 1=2.
why not simply disable or delete the expression instead of spending system resources on calculating another condition!
As an alternative, why not concatenate all values and show them in a listbox, then switch the listbox to Tree View?