Solved: Include $ sign on vertical axis - Qlik Community

Anonymous · ‎2016-10-10

Hi,

I've looked at some of the settings for this bar chart I have and didn't find what I was looking for.

How do I include the dollar sign ($) on the vertical axis? Example, I want to show $5,000,000, $10,000,000

Thank you

sunny_talwar · ‎2016-10-10

5 is used for how many data points you want to see on the Y-Axis. This would not be impacted by changes on the number of values on x-axis. Does that make sense?

View solution in original post

Anil_Babu_Samineni · ‎2016-10-10

Might from Number Format you can use money as $

Or Expression

='$' & YourExpression

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

sunny_talwar · ‎2016-10-10

Check this link out:

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

Anonymous · ‎2016-10-10

When I did this, it did not include the $ and it also removed my coma separators.

Anil_Babu_Samineni · ‎2016-10-10

Yes, You might use this in Num Function and share me expression

Num('$' & YourExpression, '##,##0')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2016-10-10

This is my expression

Num('$' & sum(Total), '##,##0')

and this is what it looks like

sunny_talwar · ‎2016-10-10

sidneylu‌ -

Did you look at the Rob's blog? It gives you exactly what you want.

Anonymous · ‎2016-10-10

Yes, I'm looking at that.

What does Step1 mean?

1. Assign the format, like Money, in the Number format.

sunny_talwar · ‎2016-10-10

Go on the number tab of the chart properties and select the format you wish to see. Money in your case I believe

Anonymous · ‎2016-10-10

It's still not showing. What am I missing here?? Sorry.