Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
rathnam_qv
Creator
Creator

Barchart

Hi all,

i have a barchart...it contains values on y-axis as in the attached file....

i need to display each value preceded with $ (Ex: $100000,$80000..)

can any one help ....

Thanks in advance!!!

Smiley

15 Replies
orital81
Partner - Creator III
Partner - Creator III

Use the Number Format at shown in the attached file

$ #,##0.00;$-#,##0.00

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Go to Number tab and Select the value and put the $ before the Format Pattern.

     So it should be $ #,##0.00

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
rathnam_qv
Creator
Creator
Author

Hey Ori,

Thanks for ur Replay,

But i don't want to display the values on the data points..

i need to display it in the left side of the chart

Not applicable

Hi smiley honey,

pls go Properties>Number--Put symbol "$"

symbol.png

Regards-bika

rathnam_qv
Creator
Creator
Author

Hey Bika,

thanks for ur replay

But i want to display it to each value

Regards

Smiley

er_mohit
Master II
Master II

ok

then for that value if it is dimension then put this in calculated dimension like this

=num(Fieldname,'$#########')

and write the name of field in label side

Updated By me:--

Go to This link

http://community.qlik.com/thread/57088

hope it helps

rathnam_qv
Creator
Creator
Author

Hey mohit,

thanks for ur replay,

but it's a expression value then how can i give field name for that..

Regards

Smiley

narender123
Specialist
Specialist

Hi Kaushik,

I also have the same problem.

Your solution gives the value on bar chart but question is not like that.please see Smiley untitled.png ,in that screen shot he want $ on Y axis like

$60000

$40000

$20000

Thanks.

Narender

Not applicable

i think try to concat $ sign like

='$' & fieldname

or try with expression

='$' &  yourexpression