Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sibin_jacob
Creator III
Creator III

Hiding Column in pivot table

Is it possible to hide a column in pivot table ?

3 Replies
Anonymous
Not applicable

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

Anonymous
Not applicable

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
Partner - Creator II
Partner - Creator II

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