topic Re: Barchart in QlikView

Barchart

rathnam_qv — Mon, 22 Jul 2013 13:50:57 GMT

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

Re: Barchart

orital81 — Mon, 22 Jul 2013 13:55:06 GMT

Use the Number Format at shown in the attached file

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

Re: Barchart

kaushiknsolanki — Mon, 22 Jul 2013 13:56:17 GMT

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

Re: Barchart

rathnam_qv — Tue, 23 Jul 2013 04:17:01 GMT

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

Re: Barchart

Tue, 23 Jul 2013 04:57:25 GMT

Hi smiley honey,

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

Regards-bika

Re: Barchart

rathnam_qv — Tue, 23 Jul 2013 05:14:25 GMT

Hey Bika,

thanks for ur replay

But i want to display it to each value

Regards

Smiley

Re: Barchart

er_mohit — Tue, 23 Jul 2013 05:25:24 GMT

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

Re: Barchart

rathnam_qv — Tue, 23 Jul 2013 05:36:09 GMT

Hey mohit,

thanks for ur replay,

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

Regards

Smiley

Re: Barchart

narender123 — Tue, 23 Jul 2013 05:56:16 GMT

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

Re: Barchart

Tue, 23 Jul 2013 06:01:11 GMT

i think try to concat $ sign like

='$' & fieldname

or try with expression

='$' & yourexpression

Re: Barchart

orital81 — Tue, 23 Jul 2013 06:26:17 GMT

Hi Smiley

Attached another qvw, this time I added $ to every possible place (-:

Header Expression, Expression Value, Dimention, Chart Header... just choose.

Hope that helped.

Re: Barchart

orital81 — Tue, 23 Jul 2013 06:53:06 GMT

Opps, I think now I understand what you need, did you mean that you want $ on each value in Y scale?

Like in the attached printscreen

Re: Barchart

narender123 — Tue, 23 Jul 2013 07:11:41 GMT

Hi Ori,

How to do this as shown in your screen shot??

Re: Barchart

orital81 — Tue, 23 Jul 2013 07:22:37 GMT

Hi Narender, unfortunately I couldn't perform it with QV, this is just a printscreen I added in order to clarify if this is what was requested. I think Y scale cannot get any sign except for %.

Re: Barchart

rathnam_qv — Tue, 23 Jul 2013 08:00:13 GMT

Ya Ori, Exactly

now tel me how can i achieve that

Regards

Smiley

Re: Barchart

orital81 — Tue, 23 Jul 2013 08:42:38 GMT

Hi Smily, as I wrote to Narender;

unfortunately I couldn't perform it with QV, this is just a printscreen I added in order to clarify if this is what you requested. I think Y scale cannot get any sign except for %.

I suggest to add $ in the Symbol at Number Tab (as suggested by bika_2010).

This will add $ in the top of Y scale but not beside each number.

I think that is the best possible match for your request although it's not exactly what you requested.