Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

robert2012
New 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

Re: Format of textbox

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
3 Replies

Re: Format of textbox

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
Not applicable

Re: Format of textbox

Yes

Num(YourNumber, '00.000€')

robert2012
New Contributor III

Re: Format of textbox

GREAT! Thank you

Community Browser