topic hide columns in a pivot table in QlikView

hide columns in a pivot table

mstoler — Thu, 11 Feb 2010 00:20:11 GMT

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,

hide columns in a pivot table

rwunderlich — Thu, 11 Feb 2010 02:11:08 GMT

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

hide columns in a pivot table

disqr_rm — Thu, 11 Feb 2010 04:00:17 GMT

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

hide columns in a pivot table

disqr_rm — Thu, 11 Feb 2010 04:04:31 GMT

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.

hide columns in a pivot table

Thu, 11 Feb 2010 10:37:34 GMT

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