Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try:
'£'&Your Value
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 |
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.
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