topic Re: £ symbol in QlikView

£ symbol

Wed, 09 Oct 2013 09:04:36 GMT

Hi,

Can anyone advise on amends needed to script to show closing tenant arrears with the £ symbol? At the minute only the figure appears, e.g 1011

[Address] &'<br />'& [Closing Tenant Arrears]

Cheers

Chris

mdmukramali — Wed, 09 Oct 2013 09:12:59 GMT

Dear Chris,

use '$'&' '& fieldName as FieldName

Thanks,

Mukram.

Wed, 09 Oct 2013 09:20:01 GMT

Hi Mukram,

Can you advise how full script would be written?, i.e where does your addition go?

Address] &'<br />'& [Closing Tenant Arrears]

'$'&' '& fieldName as FieldName

Cheers

Chris

mdmukramali — Wed, 09 Oct 2013 09:32:16 GMT

Dear ,

If you need the $ symbol in front of field,

'$ '& [Address] &' '& [Closing Tenant Arrears]

or if you need in front of [Closing Tenant Arrears]

try like this

[Address] &'$ '& [Closing Tenant Arrears]

Thanks,

Mukram