$ in y -axis label

[#1]

Hi,

I have month as dimension, sum(amt) as expression in a bar chart.

In y -axis display I can see numbers but want $ to be prefixed to numbers.

Can any 1 tell me the way

[Chanty4u]

try this

[ahammadshafi]

I think as you want the symbol as prefix, you can try this

[#4]

I tried this; we get $ and numbers below it in y-axis but numbers wont be prefixed with $

[jonathandienst]

Rather than using the scaling options on the Number tab, select the Money option.

[Anonymous]

Hi

try this:

In the expression tab add one more :

='Total year Sales : ' & Num(Sum(Sales),'$(MoneyFormat)', '#,##0')

[Chanty4u]

try selecting money option on same tab

[#8]

I am Not saying that the expression values to be prefixed with $ but its referenced y-axis data to be prefixed with $.

See the attached qvw for better scale.

[#9]

we can see tat y-bar values ranging from 0 to 400 are displayed as numbers ; I want them to be prefixed with $

[MK_QSL · Accepted solution]

like this?

But this will work if chart height is enough to show static step (go to axis tab)

Source : Currency and Other Symbols on the Y-Axis | Qlikview Cookbook