Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Comma in Y Axis Value

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.

Untitled.jpg

Thanks in advance.

8 Replies
Not applicable

Comma in Y Axis Value

in ur expression:

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

eg:

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

Comma in Y Axis Value

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

Not applicable

Comma in Y Axis Value

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.

Not applicable

Comma in Y Axis Value

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

HI,

   Have a look at the example i have attached.

Regards,

Kaushik Solanki

Not applicable

Comma in Y Axis Value

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.

Not applicable

Re: Comma in Y Axis Value

FYI all, this is the correct answer.

Re: Comma in Y Axis Value

Hi,

Kindly mark them as correct answer.

Qlik Community Tip: Posting Successful Discussion Threads

Regards,

Kaushik Solanki

Community Browser