topic VBScript Member for Expression Background Color in QlikView

VBScript Member for Expression Background Color

ysiroong — Tue, 08 Mar 2011 22:25:03 GMT

Does anyone know the VB syntax is to set the background color for an expression?

For instance, if I want to write a macro to set the expression definition I would write:


Set tbl = ActiveDocument.GetSheetObject("table")
Set exp = tbl.GetProperties
Set definition = exp.Expression.Item(0).Item(0).Data.ExpressionData.Definition
definition.v = "Sum(variable)"

How would I do the same thing to set the background for that expression? I tried the APIGuide but can't seem to find any answers there.

VBScript Member for Expression Background Color

Wed, 09 Mar 2011 01:26:42 GMT

Hi, I have not tried this but I think this will do the trick: (this is from the APIGuide; not sure if you already tried this).

set chart = ActiveDocument.ActiveSheet.CreateStraightTable
chart.AddDimension "Customer"
chart.AddDimension "ProductType"
chart.AddExpression "sum(Amount)"
set cp = chart.GetProperties
set expr = cp.Expressions.Item(0).Item(0).Data.ExpressionVisual
expr.Label.v = "Sales"
expr.LabelAdjust = 2
expr.VisualCues.LowLimit.v = 10
expr.VisualCues.LowCue.Color.Col = RGB(255,0,0) 'red
expr.VisualCues.LowCue.FontStyleMod = 2 'bold
expr.VisualCues.LowCue.SizeMod = 1 '+20%
chart.SetProperties cp

VBScript Member for Expression Background Color

ysiroong — Wed, 09 Mar 2011 14:06:46 GMT

I found the member. It's AttributeExpressions under the IExpressionDataEx class. From the APIGuide:


set chart = ActiveDocument.Activesheet.CreatePivotTable
chart.AddDimension "ProductType"
chart.AddExpression "sum(Amount)"
set cp = chart.GetProperties
set expr = cp.Expressions.Item(0).Item(0).Data
set bce = expr.AttributeExpressions.BkgColorExp
bce.Definition.v = "if(ProductType='Soap', red(), yellow())"
chart.SetProperties cp

Re: VBScript Member for Expression Background Color

a_yershov — Tue, 05 Nov 2019 10:21:58 GMT

Thanks, dude! You've saved me!