topic Re: £ symbol in QlikView

£ symbol

Wed, 09 Oct 2013 09:05:24 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

Re: £ symbol

swuehl — Wed, 09 Oct 2013 09:26:40 GMT

You can get the pound sign on windows computers using ALT + 0 1 6 3

(press ALT key and then on number pad only the four keys 0 1 6 3, while keeping the ALT key pressed).

Or try copying the character to your script / expression dialog:

Let varPound = '£';

Re: £ symbol

ngulliver — Wed, 09 Oct 2013 09:29:38 GMT

Hi, Chris.

Are you referring to simply adding a £ sign in

i.e. [Address] &'<br />' & '£' & [Closing Tenant Arrears]

or creating a new field containing the value

i.e . '£' & [Closing Tenant Arrears] as [Prefixed Closing Tenant Arrears]

or are you looking to display a £ sign in charts and tables, in which case you can go to the Number tab in your chart, choose Money format and suffix a £ to how the figure is displayed ?

Cheers,

Neil

Re: £ symbol

ngulliver — Wed, 09 Oct 2013 10:29:49 GMT

Hi, Chris.

I notice that you have posted the same question in the App Development forum.

If you have a correct answer would you be able to mark it as so to close the discussion, please ? If you have not got a satisfactory answer, I recommend closing one of the questions anyway otherwise you might get inundated with duplicated suggestions.

Many thanks,

Neil