Currency Symbols in front of text

[#1]

Hi All

I have a field in my script which is a banding field.

Results come out as 100k, 250k, 500k

I then put these in a slider on my dashboard.

Is there anyway to put a £ sign in front of these values????

Thanks

Andrew

[robert_mika]

Try:

'£'&Your Value

[MK_QSL]

Use Money function...

money(expression [ , format-code [ , decimal-sep [ , thousands-sep ] ] ])

The money function formats the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the number format that is set in the operating system will be used.

Examples:

The examples below assume the two following operating system settings:

	Default setting 1	Default setting 2
Money format	kr # ##0,00	$ #,##0.00

money( A ) where A=35648 returns:

	Setting 1	Setting 2
String	kr 35 648,00	$ 35,648.00
Number	35648.00	35648.00

money( A, '#,##0 ¥', '.' , ',' ) where A=3564800 returns:

	Setting 1	Setting 2
String	3,564,800 ¥	3,564,800 ¥
Number	3564800	3564800

[#4]

Hi, the problem is i am not using an expression... I am using slider which has not an option to enter the £..

I have the format set to show the £ sign but because these are not number it is not going in front of them...

The fields in the source data are 100k,200k,500k. These are not numbers which have been grouped by qlikview in a slider.

It would be the same question if i was to say how do i put a £ in front of a list of countries.

[#5]

Hi Andrew,

go into properties then on the Field drop down select expression, in side expression use the function.

here, I am replacing 'k' into '$'(dollar).

=Replace(SAL,'k','$')

Hope, it'll help you

Regards

Rakesh