topic Re: Hide a column (expression) in a pivot table in QlikView

Hide a column (expression) in a pivot table

Thu, 01 May 2014 17:37:45 GMT

I am looking to hide a column which is an expression within a pivot table. I was able to use conditional logic to hide the column but it in turn hides all of my columns. The column I am trying to hide is the only dimesion in the pivot, the rest are dimensions. How can I just hide this one column?

Re: Hide a column (expression) in a pivot table

rwunderlich — Thu, 01 May 2014 17:44:44 GMT

Uncheck "Suppress Zero Values" on the Presentation pane. That will allow your Dimension columns to display even when you have no enabled expression.

-Rob

Re: Hide a column (expression) in a pivot table

Thu, 01 May 2014 19:07:07 GMT

I did that, but it removes all the conditional formatting I have on the pivot chart. Any way to retain the formatting?

Re: Hide a column (expression) in a pivot table

Thu, 01 May 2014 19:58:58 GMT

you can use a onetime macro run to hide a column

sub hide

call HideColumn(''CH10",1)

End sub

private sub HideColumn(ch,n)

set ch = activeDocument.getsheetobject(ch)

ch.setpixwidth(n-1,0)

end sub

Re: Hide a column (expression) in a pivot table

rwunderlich — Thu, 01 May 2014 20:06:09 GMT

Yes, that is a weird limitation -- You don't get formatting on Dimensions unless you have an Expression displayed. A couple of workarounds I've used.

1. Make the last dimension an expression.

2. Make a dummy expression =' ' and drag the column to be very small.

-Rob