topic Money formatting in QlikView

Money formatting

Tani — Sat, 16 Nov 2024 18:34:43 GMT

Hi,

How can we format a big number, such as 12345678910 into euro format € 12.345.678,910?

#.##0,00 €;-#.##0,00 € -- this desn't seem to work for me.

P.S. I am editing in Notepad++ and I would like to declare in the right format at the time of loading the table.

Thanks,

Adi

martinpohl — Thu, 28 May 2020 07:58:25 GMT

show your script

money(Yourfield,'#.##0,00 €') as YourfieldMoney

should work

Tani — Thu, 28 May 2020 08:14:02 GMT

Thanks for the answers. I tried it and the result is not as I need it to be.

the code:display: