Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
robert2012
Contributor III
Contributor III

Format of textbox

Hi all,

I am using a textbox for showing results (number).

Is it possible to change the format of the numbers.

I would like to have a separator and the € in the number like:

23000 => 23.000€

Is this possible?

Thank for helping!


1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try num(23000, '#.##0€')

num( 23000, '#.##0€',',','.') if you need to override the document settings for decimal and thousands separators


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

Try num(23000, '#.##0€')

num( 23000, '#.##0€',',','.') if you need to override the document settings for decimal and thousands separators


talk is cheap, supply exceeds demand

View solution in original post

Not applicable

Yes

Num(YourNumber, '00.000€')

robert2012
Contributor III
Contributor III
Author

GREAT! Thank you