topic Load Script is not converting a number in QlikView

Load Script is not converting a number

brunolelli87 — Wed, 25 Nov 2020 16:16:04 GMT

Dears,

The following code is not properly converting the number to Currency.

Money#(Money(@25,'R$ #.##0,00;-R$ #.##0,00',',','.')*1000,'R$ #.##0,00;-R$ #.##0,00', ',', '.') as LOPP

But, after loading the script, I can Change it on Chart Properties > Number > Money

So, my question is:
How can I convert it without need to do those 2 steps. I want to convert it via LOAD Script.

How can I do it?

Thanks

Re: Load Script is not converting a number

tabletuner — Fri, 15 May 2020 21:18:25 GMT

You might be helped with using the notation settings in the doucment properties. Changes you make there will be valid for the field in the whole document.

Re: Load Script is not converting a number

Or — Fri, 15 May 2020 21:37:58 GMT

Why are you using Money#() on Money() in the first place? You should be able to format using just Money()?

Money(@25*1000,'R$ #.##0,00;-R$ #.##0,00',',','.') as LOPP