topic Expression label change in Module in QlikView

Expression label change in Module

azimabadi — Fri, 20 Apr 2012 08:49:00 GMT

Hi all,

i need to change the column titles (expression label) of a stright table chart in my VBScript code in module. Anybody has an idea?

Best Regards

Peyman

Fri, 20 Apr 2012 10:29:06 GMT

Hello:

Try the following VB Script, it wil change the first and second expressions labels:

Sub ChangeLabel

set Graph =ActiveDocument.GetSheetObject("CH01")

set p = Graph.GetProperties
set expr1 = p.Expressions.Item(0).Item(0).Data.ExpressionVisual

expr1.Label.v = "Sales"
expr1.NumAdjust = 1 'center
expr1.LabelAdjust = 1 'center

set expr2 = p.Expressions.Item(1).Item(0).Data.ExpressionVisual

expr2.Label.v = "Profit"
expr2.NumAdjust = 1 'center
expr2.LabelAdjust = 1 'center

Graph.SetProperties p

End Sub

cotiso_hanganu — Thu, 19 Oct 2017 14:10:32 GMT

In Qlik 12 seems to work only if you call first :

dim p

dim expr1

dim expr2

(before the sets)