topic Show percent in macro in QlikView

Show percent in macro

Tue, 30 Oct 2012 16:42:37 GMT

Hello.

I have a chart that its expressions are introduced dinamically by a macro, but I don´t know how to set the option show in %. How can I activate this optinon in the macro???

Thanks.

Re: Show percent in macro

MayilVahanan — Tue, 30 Oct 2012 17:29:12 GMT

For number presentation in macro:

Sub ChartNumberFormat

set chart = ActiveDocument.GetSheetObject("CH01")

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

End Sub

But why you can go for macro?

Try like this

Exp:

=num(Sum(Sales),vNum)

In button:

Set variable:

variable: vNum

value: =if(vNum = '#,##0','#,##0%','#,##0')

Hope it helps

Re: Show percent in macro

Wed, 31 Oct 2012 07:58:52 GMT

ThankYou!!!