inconsistent number formats.....!

[infosense_devel]

Hello,

facing issue on number format, in one same chart object it is giving different results like,

and changing some filter selection it be like,

i'm using this number format in properties as I need in two decimal place for all like 1st chart,

Thanks in Advance..!

[sunny_talwar]

See if following the instructions on this site helps

Currency and Other Symbols on the Y-Axis | Qlikview Cookbook

[infosense_devel]

I have already set number format for 2 decimal place but it is not working properly.

it will show sometime in decimal and sometime not.

[sunny_talwar]

did you look at static step part from the post?

[infosense_devel]

Yes I have tested with different value in static step but it is working in some cases and not in all.

I know it is totally dependent on data but any other solution???

[sunny_talwar]

Would you be able to replicate this issue in a sample document? I guess it will be easier to try out few things

[marcus_sommer]

It might be necessary to set all scaling-parameters with expressions. Means to increase or decrease the step-width depending on the min- and max-values and also setting these parameters directly.

Another thought - did you try to format your expression with a num() function instead of using the number-tab?

- Marcus

[Peter_Cammaert]

Apparently it isn't strictly dependent on data, rather on the layout and size of all sub-elements of your chart.

Did you try increasing the height of your chart? And the width of the Y-axis area (by reducing the line chart area)? With your second set of selection values, do the properly formatted labels ever reappear?

It may be that QlikView switching back to the default dynamic label formatting cannot be avoided in some cases.