Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sibin_jacob
Contributor III

Hiding Column in pivot table

Is it possible to hide a column in pivot table ?

3 Replies
jsn
Honored Contributor

Re: Hiding Column in pivot table

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

rathodniky
Contributor

Re: Hiding Column in pivot table

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
Contributor II

Re: Hiding Column in pivot table

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

Community Browser