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
I need it to be 90% in my qlikview.
you can divide it by 100 in the load script and in your expressions (in the chart) format the number as percentage.
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.
num(FieldName, '#,##0.00%') as FieldName,
Fieldname & '%' as Fieldname
Retrieving data ...