Formatting using Num

[risabhroy_03]

I have a field whose value is coming as 0.87141564455678.

I want to show it as 88% in the front end but I want to do the calculation on the data load editor.

Please help.

[Or]

Dual(Ceil(Value,0.01),Value) perhaps? It doesn't matter if you use it on the front end or in data load, it'd still be the same syntax.

[AronC]

Just use the num-function. For % just use the code below in your load script. Num function works the same in script and front end.

Load

num(FieldName,'0%') as FieldNameFormatted

....

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunc...