topic Re: Hide expression column in QlikView

Hide expression column

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

I would like to hide the expression column. Is this possible?

Re: Hide expression column

krishnacbe — Tue, 28 Feb 2017 21:07:55 GMT

Hi,

You are using Pivot table I hope. you cant Hide a expression in Pivot table.

You can convert the Pivot table to straight table and go to Presentation tab to Hide the expression.

Re: Hide expression column

vishsaggi — Tue, 28 Feb 2017 21:20:15 GMT

How many expressions you have in this pivot.

Can you try checking Conditional option in Expression tab of your pivot properties and set the value to 0. like here:

Re: Hide expression column

Anil_Babu_Samineni — Wed, 01 Mar 2017 02:38:25 GMT

I doubt, How Conditional enable is helps you.

Here, What if second expression is depends on column(1). If you enable conditional as 0 for first one second expression should show null values only. I am not sure how you are handling and which bases you are modifying. Can you describe more your requirement to know the insight of User

Re: Hide expression column

fanninam — Wed, 01 Mar 2017 14:03:46 GMT

Anil,

There is only one expression. When I set the one expression conditional as 0 it hid the column.

Re: Hide expression column

Anil_Babu_Samineni — Wed, 01 Mar 2017 15:36:20 GMT

Even if you have one expression, Then what is the use to create the Object here.

I know you got the answer, But some clarification to know your intend

Re: Hide expression column

fanninam — Wed, 01 Mar 2017 19:17:58 GMT

Hi Anil,

I want to show the employee names and their title but not show the headcount column.