topic Re: Hiding Column in pivot table in QlikView

Hiding Column in pivot table

sibin_jacob — Thu, 26 Jul 2012 05:43:07 GMT

Is it possible to hide a column in pivot table ?

Anonymous — Thu, 26 Jul 2012 05:48:16 GMT

You can use the conditional expression box for the expressions to only show them when certain conditions are met.

Anonymous — Thu, 26 Jul 2012 06:04:09 GMT

Hi Sibin,

You can use conditional formatting expression or you can write a macro to make coloumn width Zero

Macro would be on expression:

set chart = ActiveDocument.GetSheetObject("CH01") 'Your object ID

set p = chart.GetProperties

set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual

expr.ColWidth = 0

chart.SetProperties p

stantrolav — Fri, 24 Jan 2014 07:51:38 GMT

Write =False() in condition. All Expressions would count for this hided dimension as well.