Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
shubham_kumar
Contributor III

In bar chart $ symbol can't be prefixed to the numbers in y-axis?

Hi,

I am just wondering that don't we have option to put $ symbol to be prefixed infront of numbers in y-axis in bar charts.

Please find the attached document, if I am not clear.

$symbol.png

Best Regards,

Shubham Kumar

Tags (4)
8 Replies
nagaiank
Valued Contributor III

Re: In bar chart $ symbol can't be prefixed to the numbers in y-axis?

Try changing the settings in the Number tab of the chart properties to Money and add $ in the Symbol box.

This adds $ sign on top of the y-axis and in the values on the data points.

shubham_kumar
Contributor III

Re: In bar chart $ symbol can't be prefixed to the numbers in y-axis?

Thanks for your reply. However I was able to achieve the solution which you have provieded. My question is only in y-axis, in front of all the number $ symbol should be coming. like $1000000, $ 2000000, $ 3000000 etc. is that possible. I have tried in changing the money format and other this like adding $ in format as well, but didn't work

If you have any solution, please let me know.

thanks & regards

shubham

jason_michaelid
Honored Contributor II

Re: In bar chart $ symbol can't be prefixed to the numbers in y-axis?

As previously suggested you can get the $ symbol at the top of the axis, but not against each value.

shubham_kumar
Contributor III

Re: In bar chart $ symbol can't be prefixed to the numbers in y-axis?

That's fine, I wanted to have against each value in the  axis. Anyway's thanks for your clarification.

Best,

skumar

jason_michaelid
Honored Contributor II

Re: In bar chart $ symbol can't be prefixed to the numbers in y-axis?

I've tried to sort that before with no luck.

Please mark an answer to close the thread.

Cheers,

Jason

emilhizer
New Contributor II

Re: In bar chart $ symbol can't be prefixed to the numbers in y-axis?

When I added a value to the "Static Step" (in the Axis tab) for the Expression that's on the secondary Y-Axis, then the secondary Y-Axis on the chart picked up the number format of that Expression (from the Number tab).

Bug or feature? Not sure, but it seemed to work.

flyingcheesehea
Contributor II

Re: In bar chart $ symbol can't be prefixed to the numbers in y-axis?

Good find Eric.


I've created a code snippet that you can put into the expression window for Static Step so that you still get a good-looking chart:

=round(max(aggr(<expression>,<dimension>))/<number of chart divisions>,5*pow(10,floor(log10(max(aggr(<expression>,<dimension>))))-1))

It's a good idea here to set your expression to a variable so that when you need to change the expression it's changed everywhere. For example, if you had a chart showing sum of sales by year, you'd do something like this:

Set veSumSales = num(sum(Sales),'$#,###,###') //Do this in script or just set it in the Variable Overview

For the chart expression, just use =$(veSumSales)

For the chart dimension, set it to Year

For the Static Step, assuming we want a 0 and three additional labels on the axis, in this example you would use:

=round(max(aggr($(veSumSales),Year))/3,5*pow(10,floor(log10(max(aggr($(veSumSales),Year))))-1))

In the event you have multiple expressions, you'd need to wrap each one up in a Max(Aggr(<expression>,<Dimension(s)>)) and then wrap that whole thing in a RangeMax function.

fergal_duggan
New Contributor

Re: In bar chart $ symbol can't be prefixed to the numbers in y-axis?

This is a great answer.  Thanks

Community Browser