Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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..