Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

You need to specify the delimiters,too, like

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

View solution in original post

3 Replies
swuehl
MVP
MVP

You need to specify the delimiters,too, like

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

View solution in original post

Not applicable
Author

Thank you !

krishna20
Specialist II
Specialist II

Hi

Hope it helps.

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