topic Hiding a column in QlikView

Hiding a column

Wed, 21 Oct 2009 03:22:21 GMT

Is it possible to hide an expression column in a pivot table chart, I'm not seeing anyhting?

Hiding a column

Wed, 21 Oct 2009 03:36:29 GMT

You can disable it and it won't show up. A straight table has a conditional show for expressions under the Presentation tab.

Are you trying to show it in some cases and hide it in others? Maybe explain what you are trying to do, we can offer a suggestion.

Hiding a column

Wed, 21 Oct 2009 03:50:29 GMT

I have 2 columns that I am simply using in a formula that gives me a value in another column. I would like to have the columns hidden. I know in the straight table I can hide the coulmn, but I'm using a pivot table and would like to hide the column.

Hiding a column

Wed, 21 Oct 2009 04:57:57 GMT

I don't think that is possible in a pivot.

What is the expression that you want to show? Can you combine the multiple expressions into one big one?

An alternative would be to set up variables instead of expressions and put your expressions into the variable values. You can then use a dollar sign-expansion along with the variable in your expressions.

vExp1 = Sum(Sales)
vExp2 = Sum(Costs)
Exp = $(vExp1)/$(vExp2)

Re: Hiding a column

Anonymous — Sun, 02 Feb 2014 20:03:29 GMT

In Qlikview 11 Version only,You can use the conditional expression box for the expressions to only show them when certain conditions are met.