Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

Hide expression column

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

1 Solution

Accepted Solutions
Highlighted
Esteemed Contributor III

Re: Hide expression column

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:

Capture.PNG

View solution in original post

6 Replies
Highlighted
Partner
Partner

Re: Hide expression column

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.

Highlighted
Esteemed Contributor III

Re: Hide expression column

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:

Capture.PNG

View solution in original post

Highlighted

Re: Hide expression column

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor

Re: Hide expression column

Anil,

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

Highlighted

Re: Hide expression column

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor

Re: Hide expression column

Hi Anil,

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