Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Change Number Format in a Textbox

Hi

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

3 Replies
MarcoWedel

Hi,

maybe like this:

QlikCommunity_Thread_284616_Pic1.JPG

hope this helps

regards

Marco

Anonymous
Not applicable
Author

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

Glad it worked.

Please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco