topic Convert number in percentage in loading script in QlikView

Convert number in percentage in loading script

Mon, 24 Aug 2015 12:50:54 GMT

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

I need it to be 90% in my qlikview.

Kind Regards,

Hasvine

Re: Convert number in percentage in loading script

maleksafa — Mon, 24 Aug 2015 12:56:26 GMT

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

Re: Convert number in percentage in loading script

Peter_Cammaert — Mon, 24 Aug 2015 13:02:24 GMT

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

Re: Convert number in percentage in loading script

chaper — Mon, 24 Aug 2015 13:03:00 GMT

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

Re: Convert number in percentage in loading script

Anonymous — Mon, 24 Aug 2015 13:03:04 GMT

hi,

Try:

Fieldname & '%' as Fieldname

Regards

Neetha