topic Re: How to hide expression in pivot table in QlikView

How to hide expression in pivot table

yoganantha321 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

Regards,

Yoganantha Prakash G P

vinieme12 — Fri, 02 Jun 2017 11:55:37 GMT

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

Sergey_Shuklin — Fri, 02 Jun 2017 12:16:51 GMT

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.

sudeepkm — Fri, 02 Jun 2017 13:13:38 GMT

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

vinieme12 — Fri, 02 Jun 2017 13:44:18 GMT

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

Peter_Cammaert — Fri, 02 Jun 2017 13:49:15 GMT

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