Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
try this
I think as you want the symbol as prefix, you can try this
I tried this; we get $ and numbers below it in y-axis but numbers wont be prefixed with $
Rather than using the scaling options on the Number tab, select the Money option.
Hi
try this:
In the expression tab add one more :
='Total year Sales : ' & Num(Sum(Sales),'$(MoneyFormat)', '#,##0')
try selecting money option on same tab
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.
we can see tat y-bar values ranging from 0 to 400 are displayed as numbers ; I want them to be prefixed with $
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