topic Re: European currency format in Text Object in QlikView

European currency format in Text Object

Thu, 05 Nov 2015 15:09:58 GMT

Hi Guys

Please I can anyone help me to get the right European standard format for currency in a Text object. For example € 218,015.25 should be € 218.015,25. I can't figure out how to get the right format in a text object but in charts its easy. I used € ,###.## and its only presented as € 218,015.25 that's not what I want but, € 218.015,25.

Thanks,

Simon

Re: European currency format in Text Object

Gysbert_Wassenaar — Thu, 05 Nov 2015 15:22:58 GMT

Add the decimal and thousands separators as additional parameters: num(MyValue, '€ #.##0,00',',','.')

Re: European currency format in Text Object

Mark_Little — Thu, 05 Nov 2015 15:28:03 GMT

Hi Simon,

Using the Format #.##0,00, should show what you want,

Mark

Re: European currency format in Text Object

Thu, 05 Nov 2015 15:40:14 GMT

Hi Gysbert,

Thanks alot it worked just fine. I really appreciate it.