Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Mastering Change Data Capture: Read Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Property that show in Percent

At example below, teaches how modify number properties, but i did not found what show in percent.

Anyone can help me?

set chart = ActiveDocument.Sheets("Main").CreateStraightTable
chart.AddDimension "ProductType"
chart.AddExpression "sum(Amount)"
set p = chart.GetProperties
set np = p.Expressions.Item(0).Item(0).Data.ExpressionVisual.NumberPresentation
np.Dec = "."
np.Fmt = "# ##0.00"
np.nDec = 2
np.Thou = " "
np.Type = 11 'fixed decimal
np.UseThou = 1
chart.SetProperties p

1 Reply
disqr_rm
Partner - Specialist III
Partner - Specialist III

What I know it that you need to calculate the percent value and then use format as follows:

np.Fmt = "# ##0.00%"