topic Comma in Y Axis Value in QlikView

Comma in Y Axis Value

Tue, 12 Jul 2011 05:56:34 GMT

Hello Guys,

I want to display comma symbol in Y-Axis Values which is the money. So how can do that without formatting in Number tab..? Is there any option you know..?

For your reference I have attached the pic of the chart below.

Thanks in advance.

Comma in Y Axis Value

Tue, 12 Jul 2011 06:06:59 GMT

in ur expression:

num(expression,'#,##0.00 ')

eg:

Num(Sum(Sales),'#,##0.00 ')

Comma in Y Axis Value

kaushiknsolanki — Tue, 12 Jul 2011 06:13:28 GMT

Hi,

There is another way too.

Go to Properties of Chart -> Number -> Select the expression you want with ','

Select the number format you want like Number Integer etc

See the Format Pattern, and give , here or type like this #,##0

Regards,

Kaushik Solanki

Comma in Y Axis Value

Tue, 12 Jul 2011 06:21:18 GMT

Hi Erika,

Thanks for your reply.

I have already tried that. Its working for Values inside the chart only. But I want to change the format of Values in Y Axis.

Thanks in advance.

Comma in Y Axis Value

Tue, 12 Jul 2011 06:34:36 GMT

Hi!

In my charts its showing the Y axis values with commas.

I can't figure out the prblm in urs.

Sorry...

Re: Comma in Y Axis Value

kaushiknsolanki — Tue, 12 Jul 2011 06:53:12 GMT

HI,

Have a look at the example i have attached.

Regards,

Kaushik Solanki

Comma in Y Axis Value

Fri, 09 Sep 2011 23:08:17 GMT

Looks like when you turn on the Log scale for the y-axes under the "Axes" tab the commas won't show.

They show if the Log scale is turned off.

Re: Comma in Y Axis Value

Thu, 18 Feb 2016 14:06:24 GMT

FYI all, this is the correct answer.

Re: Comma in Y Axis Value

kaushiknsolanki — Thu, 18 Feb 2016 17:48:32 GMT

Hi,

Kindly mark them as correct answer.

Qlik Community Tip: Posting Successful Discussion Threads‌

Regards,

Kaushik Solanki