Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Format of a number in a textbox

Hey everyone,

In a textbox, I show the result of an expression. I get 55695 and I would like to display 55 695, with a space for the separator for the thousand.

I've tried several things, among them:

= Num (myvalue, '# ##0')

but it doesn't work.

Any ideas ?

Thank you for your help

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Format of a number in a textbox

You need to specify the delimiters,too, like

= Num (myvalue, '# ##0','.',' ')

3 Replies
Highlighted
MVP
MVP

Re: Format of a number in a textbox

You need to specify the delimiters,too, like

= Num (myvalue, '# ##0','.',' ')

Not applicable

Re: Format of a number in a textbox

Thank you !

krishna20
Valued Contributor II

Re: Format of a number in a textbox

Hi

Hope it helps.

=Num(sum([Annual Salary]),'#,##0')