topic Re: Can we hide a Expression Column in QlikView

Can we hide a Expression Column

Thu, 05 Mar 2015 11:03:50 GMT

Hi Friends,

I am trying to hide the first column of expressions in pivot chart by using the following macro. But when we reload data again its hiding other column which now takes fist index. Can we tweak the macro so that it always hides the first expression irrespective of selections in pivot chat??

Public Sub hide

Call HideColumn("CH67",1)

End Sub

Private Sub HideColumn(ch,n)

Set ch = activeDocument.getsheetobject(ch)

ch.setpixwidth(n),0

End Sub

Thanks

Re: Can we hide a Expression Column

Anonymous — Thu, 05 Mar 2015 11:45:33 GMT

You can hide the expressions without using a macro. Go to the expression tab. Check the conditional option and give the condition for which you want to hide it.

Re: Can we hide a Expression Column

awhitfield — Thu, 05 Mar 2015 11:54:43 GMT

Hi Pavan,

On the Presentation Tab, select the expression and then click 'Hide' Column'

Regards

Andy