Change Percentage Decimal Separator

[micheledenardi]

Dear all,

i would like to change the decimal separator from comma (,) to dot (.)

So, the third column now is -56,82% and using Num() function i would like to obtain -56.82%

I already tried these solution but the result is not correct.

Ideas?

[justISO]

Hi, choose 'Custom' formatting and set format you want:

[micheledenardi]

I cannot set "fixed" formatting in the properties of the measure because i have worldwide users and some of them use dot as decimal separator, other use comma.

That's the reason why i need to obtain the correct result using Num() (i'll manage the correct number formatting using a user-variable  as second parameter in Num()).

If i try to apply your formatting the result is still incorrect.

[vinieme12]

You can change the decimal separator for the application by setting the below parameter in your script 

Set DecimalSep=','; << Change from . To ,

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/NumberInte...

[justISO]

try this then: Num(column(1)/column(2)-1,'#.##%', '.')

[micheledenardi]

No,

it doesn't works

[micheledenardi]

Dear @vinieme12, due to the situation i explained above (worldwide users with different decimal separators), i cannot set fixed formatting at App/Object level. i need to reach the result using Num() function.

[micheledenardi]

Any solution?