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

How to hide a expression in pivot table?

Fri, 27 Mar 2015 13:22:30 GMT

Hello everyone,

I am using two expressions in pivot table. I am using the first expression(name) to derive the second expression so I cant disable it.

I just want to hide it.

Also I cannot directly use the first expression as is in the second expression as I have used Range function in it.

Any idea how to hide the first expression(Not disabling it).

Regards,

Pratik

Re: How to hide a expression in pivot table?

jonathandienst — Fri, 27 Mar 2015 13:30:01 GMT

I don't think you can hide a pivot table expression directly. You could set the foreground colour of the first expression to white, set the label to ' ' (space) and make it as narrow as possible to make it (almost) disappear.

On the Style tab, uncheck "Vertical Expression Cell Borders" to avoid the appearance of an empty cell.

HTH

Jonathan

Re: How to hide a expression in pivot table?

JonnyPoole — Fri, 27 Mar 2015 13:32:31 GMT

Just with formatting tricks...

Here my first expression label is just a space ( ' ' ) and you can reference it in the 2nd expression using [ ].

Disabled vertical borders on expressions and use transparent text color or show text as image and hide when not available.

Re: How to hide a expression in pivot table?

nicolett_yuri — Fri, 23 Oct 2015 13:46:26 GMT

You can use a macro.

Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)