Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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