topic Re: Include $ sign on vertical axis in QlikView

Include $ sign on vertical axis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Include $ sign on vertical axis

Anil_Babu_Samineni — Mon, 10 Oct 2016 15:42:35 GMT

Might from Number Format you can use money as $

Or Expression

='$' & YourExpression

Re: Include $ sign on vertical axis

sunny_talwar — Mon, 10 Oct 2016 15:43:59 GMT

Check this link out:

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

Re: Include $ sign on vertical axis

Anonymous — Mon, 10 Oct 2016 15:44:06 GMT

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

Re: Include $ sign on vertical axis

Anil_Babu_Samineni — Mon, 10 Oct 2016 15:46:38 GMT

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

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

Re: Include $ sign on vertical axis

Anonymous — Mon, 10 Oct 2016 15:51:12 GMT

This is my expression

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

and this is what it looks like

Re: Include $ sign on vertical axis

sunny_talwar — Mon, 10 Oct 2016 15:52:24 GMT

sidneylu‌ -

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

Re: Include $ sign on vertical axis

Anonymous — Mon, 10 Oct 2016 15:55:43 GMT

Yes, I'm looking at that.

What does Step1 mean?

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

Re: Include $ sign on vertical axis

sunny_talwar — Mon, 10 Oct 2016 15:58:20 GMT

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

Re: Include $ sign on vertical axis

Anonymous — Mon, 10 Oct 2016 16:02:57 GMT

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

Re: Include $ sign on vertical axis

Anil_Babu_Samineni — Mon, 10 Oct 2016 16:05:23 GMT

Try luck, Change your environment

SET MoneyFormat='$ #.##0,00;-$ #.##0,00';

Or share me your application

Re: Include $ sign on vertical axis

sunny_talwar — Mon, 10 Oct 2016 16:05:50 GMT

Did you follow this?

You might have to use 5,000,000 instead of 1 here

Re: Include $ sign on vertical axis

Anonymous — Mon, 10 Oct 2016 16:10:13 GMT

Yes, I put in 5,000,000 for the step. It worked. However what's going to happen when my values are small?

Will this work all the time??

Re: Include $ sign on vertical axis

sunny_talwar — Mon, 10 Oct 2016 16:14:24 GMT

Use a dynamic expression for Static Step. May be something like

Sum(Measure)/5

Re: Include $ sign on vertical axis

Anonymous — Mon, 10 Oct 2016 16:20:07 GMT

OK, let me play around with this. I modified my data so the values are much smaller. This did not work. The $ disappeared.

Re: Include $ sign on vertical axis

Anonymous — Mon, 10 Oct 2016 16:21:37 GMT

This was already in my load script. Obviously this didn't help either.

Re: Include $ sign on vertical axis

sunny_talwar — Mon, 10 Oct 2016 16:21:41 GMT

Would you be able to share what you have and may be I can offer some work around

Re: Include $ sign on vertical axis

Anonymous — Mon, 10 Oct 2016 16:24:13 GMT

Thank you so much. I will try to create a sample app with this data. Will upload a bit later today.

Re: Include $ sign on vertical axis

sunny_talwar — Mon, 10 Oct 2016 16:25:09 GMT

Sounds good

Re: Include $ sign on vertical axis

sunny_talwar — Mon, 10 Oct 2016 16:41:53 GMT

Try the attached

With no selection:

With Selection

Expression used for static steps

Max(Sales)/5