topic Adding a £ in an expression in QlikView

Adding a £ in an expression

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Adding a £ in an expression

sunny_talwar — Mon, 20 Jun 2016 15:36:00 GMT

May be like this:

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

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

Re: Adding a £ in an expression

effinty2112 — Mon, 20 Jun 2016 16:09:38 GMT

Hi Dave,

Try

=Money(YourExpression)

cheers

Andrew

Re: Adding a £ in an expression

Tue, 21 Jun 2016 08:54:13 GMT

perfect thanks