Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding a £ in an expression

Hi,

I have done a calculation between two monetary values in a text object. I would like to add a £ at the front and enter the thousand separator(,). Any ides how I can do this

1 Solution

Accepted Solutions
sunny_talwar

May be like this:

Num(YourExpression, '£ #,##0.00')

or

Num(YourExpression, '£ #,##0.')

View solution in original post

3 Replies
sunny_talwar

May be like this:

Num(YourExpression, '£ #,##0.00')

or

Num(YourExpression, '£ #,##0.')

effinty2112
Master
Master

Hi Dave,

               Try

=Money(YourExpression)

cheers

Andrew

Not applicable
Author

perfect thanks