topic Re: Axis Number Format in QlikView

Axis Number Format

manojkulkarni — Tue, 09 Jun 2015 10:26:04 GMT

Hi Team,

I would like to change the display numbers in Axis to specific format. How can we achieve this ?

Always the representation is fixed to thousand separator. I would like to change as per geography.

avinashelite — Tue, 09 Jun 2015 10:28:05 GMT

Go to Chart properties and Number tab, here you should get the option to do.

OR even you can do it using the NUM() function too

manojkulkarni — Tue, 09 Jun 2015 10:32:42 GMT

I have tried both the options, it doesn't work. If working for you pls send me working app.

MarcoWedel — Tue, 09 Jun 2015 10:50:23 GMT

please post an example app and your format requirements.

thanks

regards

Marco

manojkulkarni — Thu, 11 Jun 2015 07:24:01 GMT

Pls find attached sample.

Value on Bar is in different format and format of axis is different. Would like to have same number format on Axis as well

avinashelite — Thu, 11 Jun 2015 07:52:13 GMT

Please find the attachment for the solution :

Frank_Hartmann — Thu, 11 Jun 2015 08:05:20 GMT

i think you cant use the Barchart format "#.##.##0" also on your axis.

try to change the value of one of your inlinetable data to >1000000 (e.g Blore=8000000)

and you wont get shown the correct data in chart because the format does not fit!