topic Re: Setting the Number Format Settings to "Expression Default" in a dynamic chart vb macro in QlikView

Setting the Number Format Settings to "Expression Default" in a dynamic chart vb macro

gfarrell — Wed, 20 Jan 2016 02:13:33 GMT

Is there a way to set an expression's format in a Dynamic Chart Macro that will basically follow the "Expression Default" option available on the Chart Properties Number Tab.

I am currently using the ..Data.ExpressionVisual.NumberPresentation.fmt = '#,##0' syntax and would like the expression format to default from the expressions that include Num(sum(Amount),'#,##0') syntax....

Thanks in advance.

Re: Setting the Number Format Settings to "Expression Default" in a dynamic chart vb macro

tamilarasu — Wed, 20 Jan 2016 04:33:29 GMT

Hi Greg,

Check the below attachment.

Re: Setting the Number Format Settings to "Expression Default" in a dynamic chart vb macro

HirisH_V7 — Wed, 20 Jan 2016 04:59:31 GMT

Hi ,

May be like this,

Sub CreateLineChart
set chart = ActiveDocument.Sheets("Main").CreateLineChart
chart.AddDimension "ID"
chart.AddExpression "sum(Amount)"
set p = chart.GetProperties
p.Expressions.Item(0).Item(0).Data.AxisData.Units.Unit.v = "$"
p.Expressions.Item(0).Item(0).Data.AxisData.Units.kUnit.v = "1000$"
p.Expressions.Item(0).Item(0).Data.AxisData.Units.MUnit.v = "million$"
p.Expressions.Item(0).Item(0).Data.AxisData.Units.GUnit.v = "billion$"                
chart.SetProperties p
end Sub

Hope this helps,

Regards,

Hirish