Convert number in percentage in loading script

[#1]

Hello All,

Any idea how to convert number which figure on SQL to percentage in my loading script in qlikview.

Currently my table in SQL is like

QScible

90

I need it to be 90% in my qlikview.

Kind Regards,

Hasvine

[maleksafa]

you can divide it by 100 in the load script and in your expressions (in the chart) format the number as percentage.

[Peter_Cammaert]

As Malek already hinted at, percentages are internally represented as fractions between 0 (0%) and 1 (100%). Formatting does the rest. This approach makes calculations that involve percentages very easy to perform.

Peter

[chaper · Accepted solution]

num(FieldName, '#,##0.00%') as FieldName,

[Anonymous]

hi,

Try:

Fieldname & '%' as Fieldname

Regards

Neetha