Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

$ in y -axis label

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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

View solution in original post

16 Replies
Chanty4u
MVP
MVP

try this

num.PNG

ahammadshafi
Creator
Creator

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

Capture.PNG

Not applicable
Author

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

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

Hi

try this:

In the expression tab add one more :

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

Chanty4u
MVP
MVP

try selecting money option on same tab

Not applicable
Author

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.

Not applicable
Author

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
MVP
MVP

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