Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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

16 Replies
Not applicable
Author

'$'& USE THIS COMMAND BEFORE THE EXPRESSION SO U COULD GET IT

avinashelite

Try like this

Dual('$'&sum(amt),sum(amt))

Not applicable
Author

in chart properties click expression tab you may see advance mode  in that we can fix $  symbol in the desired axis

Not applicable
Author

hey bro how did you exactly get the $; I did not understand, I have seen all the properties the only thing that has been making difference is the static step, may I know wat it exactly implies and how every thing varies based on steps range like what is the difference b/w static step 1,static step 2 etc...

avinashelite

static step 1,static step 2  : means it will increment your Y-axis my steps you mention in Static steps i.e if you mention as 5 then Y-axis values change in a increment of 5 ...like

20

15

10

5

0


MK_QSL
MVP
MVP

Go to Number tab and select Money..

Now go to axis tab and do static step 1

Increase the height of chart

trdandamudi
Master II
Master II

The $ is coming from the 'Number' tab in the properties.He has selected 'Money' under Number Format Settings. Static step is the increment step. On the Y axis it is incrementing by 10 (Example: 300,310,320... so on). if you want to increment the Y axis by 50 then input 50 in Static field.

Hope this helps..