topic Re: Change Number Format in a Textbox in QlikView

Change Number Format in a Textbox

Anonymous — Mon, 11 Dec 2017 09:34:48 GMT

we are using the Swiss number Format. How can I Change in a textbox 1.5 Million from 1.500.000,00 to 1'500'000.00

I have to use ' for thousands seperator and . for decimal.

thanks for any response

MarcoWedel — Mon, 11 Dec 2017 17:53:16 GMT

Hi,

maybe like this:

hope this helps

regards

Marco

Anonymous — Tue, 12 Dec 2017 08:44:48 GMT

Hi Marco

thank you very much, it worked. But I must say, it's really a bit complicated just to change a number format.

regards

Diren

MarcoWedel — Wed, 13 Dec 2017 00:01:27 GMT

Glad it worked.

Please close your thread if your question is answered:

thanks

regards

Marco