Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
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
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
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.
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