topic Re: Macro not working in QlikView

Macro not working

anushree1 — Wed, 10 May 2017 12:05:11 GMT

Hi,

I am using the below macro to make all the expressions in a straight table to be right aligned

SUB AdjustAlign

set chart = ActiveDocument.getsheetobject("CH510")

Set cp =Chart.getproperties

X=3

FOR J= 0 to 9

set expr = cp.Expressions.Item(J).Item(0).Data.ExpressionVisual

'expr.Label.v= X

expr.NumAdjust = 1 'right

expr.LabelAdjust = 1 'center

X=X+3

chart.SetProperties cp

END SUB

But it does not seem to work when the same is used to center align things work as expected.

Can anyone please correct the above code for right aligning the straight table expression values

m_woolf — Wed, 10 May 2017 12:35:28 GMT

When I look at .NumAdjust in the API Guide, I see that 0 = left, 1 = center, and 2 = right

anushree1 — Wed, 10 May 2017 12:58:50 GMT

Can you please share the guide that you are referring to I am very new to Macros so it would help me in learning

m_woolf — Thu, 11 May 2017 10:07:23 GMT

See the attachment: