topic Re: Y axis formating in QlikView

Y axis formating

Thu, 25 Jun 2015 13:25:50 GMT

Hi All,

I have created a bar chart there with Manager as dimension and Sales as expression , in the y axis it is displaying like 10,000

but I don't want "comma", between the digits, how can I format it.

Regards

John

b_garside — Thu, 25 Jun 2015 13:32:05 GMT

Go to the Numbers tab and modify the format there. You can hard code if needed as well.

just select integer

Thu, 25 Jun 2015 13:43:52 GMT

I have done it,however it was not working.

b_garside — Thu, 25 Jun 2015 13:46:06 GMT

You can try;

Num(Sum(Sales),'###0') jsut make sure no comma is in mask formatting.

Thu, 25 Jun 2015 13:48:03 GMT

Thu, 25 Jun 2015 14:31:39 GMT

Got it I have removed thousand separator in Number tab.

b_garside — Thu, 25 Jun 2015 14:35:01 GMT

Correct that is what I suggested in my first response above 'Numbers' tab.

Glad it worked.