topic Re: Change label Expression VBScript in QlikView

Change label Expression VBScript

Sat, 28 Jun 2014 21:19:03 GMT

What is the syntax in VBScript to change the label of an Expression. For instance, I add this expression in a Pivot Table:

Hlo.AddExpression "Sum(ExpenseBudget)/1000"

and I would like the Expression to be labelled as "Expense"

Re: Change label Expression VBScript

luciancotea — Sat, 28 Jun 2014 21:32:04 GMT

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.NumAdjust = 1 'center

expr.LabelAdjust = 1 'center

chart.SetProperties cp

Re: Change label Expression VBScript

Sun, 29 Jun 2014 08:41:26 GMT

thanks for reply

in prop.Expressions.Item(0).Item(0).Data.ExpressionVisual

i understand that prop.Expressions.Item(0) is the first expressions in the list of expressions for this chart. What does the second item(0) refers to ? What is Data and what is ExpressionVisual for ?

Thanks

Re: Change label Expression VBScript

luciancotea — Sun, 29 Jun 2014 10:29:26 GMT

First item is the group of expressions, the second is the expression in group.

Look for "API Guide" to understand all the properties.