Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

How to hide expression in pivot table

Hi,

I am having a pivot table as below:

Screenshot_74.png

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!?

Regards,

Yoganantha Prakash G P

1 Solution

Accepted Solutions
Highlighted
Champion II
Champion II

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

5 Replies
Highlighted
Champion II
Champion II

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

Highlighted
Specialist
Specialist

Hello!

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.

Specialist III
Specialist III

another way of hiding the expression in Pivot table would be to put a condition like 1=2.

c262698.PNG

Highlighted
Champion II
Champion II

why not simply disable or delete the expression instead of spending system resources on calculating another condition!

Highlighted

As an alternative, why not concatenate all values and show them in a listbox, then switch the listbox to Tree View?