hide columns in a pivot table

[mstoler]

Hello,

I need to convert a straight table to a pivot table. I have made use of the feature which allows me to hide a column based on an expression.

How can I accomplish this using a pivot table (hide a column based on an expression). I am using QlikView Version 9.0.

Thank You,

[rwunderlich · Accepted solution]

I don't think this is available yet in Pivot tables. Best I've been able to do is use a text format expression to make the text same color as backgound.

-Rob

[disqr_rm]

You could add/remove expression with the help of Macros dynamically, if that helps, based on what you need:

set Graph = ActiveDocument.GetSheetObject("CH01")
Graph.AddShowValueExpression "if(sum(Amount)>10, 1, 0)",0 '0=false

[disqr_rm]

Another option would be to have multiple pivor charts and enable / disable them based on the condions. I would rather take this approach over macros. Try what works out best for your situation.

[#5]

You could make the column 0 width:

set chart = ActiveDocument.GetSheetObject("CH99") ' CHANGE THE OBJECT ID
set p = chart.GetProperties

set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual ' group.expression numbered from 0
expr.ColWidth = 0
chart.SetProperties p

However, I would use multiple charts if possible - avoid using macros whenever possible.

Regards,

Gordon