topic Re: $ in y -axis label in QlikView

$ in y -axis label

Thu, 05 May 2016 07:55:40 GMT

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

Re: $ in y -axis label

Chanty4u — Thu, 05 May 2016 08:07:27 GMT

try this

Re: $ in y -axis label

ahammadshafi — Thu, 05 May 2016 08:11:20 GMT

I think as you want the symbol as prefix, you can try this

Re: $ in y -axis label

Thu, 05 May 2016 08:11:40 GMT

I tried this; we get $ and numbers below it in y-axis but numbers wont be prefixed with $

Re: $ in y -axis label

jonathandienst — Thu, 05 May 2016 08:12:57 GMT

Rather than using the scaling options on the Number tab, select the Money option.

Re: $ in y -axis label

Anonymous — Thu, 05 May 2016 08:15:49 GMT

try this:

In the expression tab add one more :

='Total year Sales : ' & Num(Sum(Sales),'$(MoneyFormat)', '#,##0')

Re: $ in y -axis label

Chanty4u — Thu, 05 May 2016 08:17:58 GMT

try selecting money option on same tab

Re: $ in y -axis label

Thu, 05 May 2016 08:20:51 GMT

I am Not saying that the expression values to be prefixed with $ but its referenced y-axis data to be prefixed with $.

See the attached qvw for better scale.

Re: $ in y -axis label

Thu, 05 May 2016 08:30:38 GMT

we can see tat y-bar values ranging from 0 to 400 are displayed as numbers ; I want them to be prefixed with $

Re: $ in y -axis label

MK_QSL — Thu, 05 May 2016 09:39:04 GMT

like this?

But this will work if chart height is enough to show static step (go to axis tab)

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

Re: $ in y -axis label

Thu, 05 May 2016 09:42:39 GMT

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

Re: $ in y -axis label

avinashelite — Thu, 05 May 2016 09:43:50 GMT

Try like this

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

Re: $ in y -axis label

Thu, 05 May 2016 09:47:50 GMT

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

Re: $ in y -axis label

Thu, 05 May 2016 12:14:01 GMT

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...

Re: $ in y -axis label

avinashelite — Thu, 05 May 2016 12:17:21 GMT

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

Re: $ in y -axis label

MK_QSL — Thu, 05 May 2016 12:18:47 GMT

Go to Number tab and select Money..

Now go to axis tab and do static step 1

Increase the height of chart

Re: $ in y -axis label

trdandamudi — Thu, 05 May 2016 12:24:02 GMT

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..