topic Re: showing £ on an axis in QlikView

showing £ on an axis

Thu, 27 Aug 2015 08:43:09 GMT

Hi,

This may be a really sily question so apologies if it is.

Want the X Axis on a chart to show as £20,000, £40,000 etc rather than 20,000, 40,00 as it does currently.

What is the chart option or what do I need to do to get this to work?

Any help much appreciated.

Chris

Re: showing £ on an axis

avinashelite — Thu, 27 Aug 2015 08:50:17 GMT

you can add a calculated dimension like this:

'$'&your_field_name

Re: showing £ on an axis

gautik92 — Thu, 27 Aug 2015 08:59:58 GMT

='£'&Fieldname

Re: showing £ on an axis

sunilkumarqv — Thu, 27 Aug 2015 09:10:08 GMT

In you dimension

='£'&FieldName

if your not using any dimension in that case on Propertirs -Number settings use symbol =£ .

Re: showing £ on an axis

mohammadkhatimi — Thu, 27 Aug 2015 09:12:16 GMT

In dimension

='£'&FieldName

Hope this will helps you...!!

Regards,

Mohammad

Re: showing £ on an axis

Anonymous — Thu, 27 Aug 2015 09:15:33 GMT

As far as I understand your problem, you are trying to display £ and not sure how do you do that.

You can either use Chr(int) function if you know the ASCII value of this character or can copy '£' symbol from a Microsoft Word Document and paste it in your chart as Avinasha and Gowtham explained (i.e. '£' & your_field).

Hope this helps.

Regards,

Laxmi

Re: showing £ on an axis

jonathandienst — Thu, 27 Aug 2015 09:15:34 GMT

I recommend formatting it rather than turning the dimension into a string, which might mean you need a sort expression to get them to sort properly.

Either use this in a calculated dimension: =Num(Field, '£#,##0.00')

Or, go to Properties | Number, select the field and apply the same formatting £#,##0.00 to the field as the default format.

Re: showing £ on an axis

sasiparupudi1 — Thu, 27 Aug 2015 09:20:15 GMT

Hi Jonathan,

I think his question is about showing pound symbol on the axes rather than the data points.. Is there any way to show the symbol on the axes points?

Sasi

Re: showing £ on an axis

jonathandienst — Thu, 27 Aug 2015 09:41:47 GMT

If its the X-axis (as in the original question), then my suggestion should work. It certainly does in my models.

If its the Y-axis, set the format in chart properties. Go to Properties | Number, select the expression, and enter the required format eg £#,##0.00

Re: showing £ on an axis

sasiparupudi1 — Thu, 27 Aug 2015 09:59:45 GMT

Like the attached?

Re: showing £ on an axis

Anonymous — Thu, 27 Aug 2015 10:53:26 GMT

Hi Chris, good question, one way of doing this is to go to properties->presentation->text in chart. You can then add the currency code and drag it to the desired axis using Ctrl+Shift. Use 270 as the orientation. See example below.

Re: showing £ on an axis

Thu, 27 Aug 2015 12:38:15 GMT

Thanks for all your replies but little confused about to action them.

Just want to change the axis to show number in figures. The figures were wanting to show isn't a dimesnsion. It's an expression and plus not sure how this determines the axis.

Chris

Re: showing £ on an axis

Anonymous — Thu, 27 Aug 2015 12:53:16 GMT

Hi Chris, you will not be able to get a currency symbol next to each value on the axis (the figures in the above chart are also an expression - their are no dimensions in that chart.). You can however label the whole axis with the currency symbol and add more descriptive information as shown above. You can also get a symbol on top/at the end of each axis by entering the symbol on the properties->number-> symbol field. If you enter the required symbols for thousands/millions etc these will also change dynamically based on the values in your expressions. Hope this helps clarify things.

Re: showing £ on an axis

Thu, 27 Aug 2015 12:56:25 GMT

if you want the symbol and formatting on the axis, you can go to the numbers tab and for the expression, format where it has the symbol, thousand symbol, million symbol

Re: showing £ on an axis

Thu, 27 Aug 2015 13:05:21 GMT

Chart Properties > Number > Add your symbol under Symbol, Thousand Symbol, Million Symbol.

For example: £, £K, £M

Re: showing £ on an axis

qlikviewwizard — Sat, 29 Aug 2015 08:29:40 GMT

Hi Chris,

Please select correct answer/helpful answers and close the thread. Thank you.