topic inconsistent number formats.....! in QlikView https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336006#M412093 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>facing issue on number format, in one same chart object it is giving different results like,</P><P></P><P><IMG alt="1.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/163148_1.png" style="width: 620px; height: 149px;" /></P><P></P><P>and changing some filter selection it be like,</P><P></P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163141_1.png" style="height: auto;" /></P><P></P><P>i'm using this number format in properties as I need in two decimal place for all like 1st chart,</P><P></P><P></P><P><IMG alt="1.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/163149_1.png" style="width: 620px; height: 538px;" /></P><P></P><P></P><P>Thanks in Advance..!</P></BODY></HTML> Fri, 12 May 2017 10:30:48 GMT infosense_devel 2017-05-12T10:30:48Z inconsistent number formats.....! https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336006#M412093 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>facing issue on number format, in one same chart object it is giving different results like,</P><P></P><P><IMG alt="1.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/163148_1.png" style="width: 620px; height: 149px;" /></P><P></P><P>and changing some filter selection it be like,</P><P></P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163141_1.png" style="height: auto;" /></P><P></P><P>i'm using this number format in properties as I need in two decimal place for all like 1st chart,</P><P></P><P></P><P><IMG alt="1.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/163149_1.png" style="width: 620px; height: 538px;" /></P><P></P><P></P><P>Thanks in Advance..!</P></BODY></HTML> Fri, 12 May 2017 10:30:48 GMT https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336006#M412093 infosense_devel 2017-05-12T10:30:48Z Re: inconsistent number formats.....! https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336007#M412094 <HTML><HEAD></HEAD><BODY><P>See if following the instructions on this site helps</P><P><A href="http://qlikviewcookbook.com/2015/05/currency-and-other-symbols-on-the-y-axis/" title="http://qlikviewcookbook.com/2015/05/currency-and-other-symbols-on-the-y-axis/">Currency and Other Symbols on the Y-Axis | Qlikview Cookbook</A></P></BODY></HTML> Fri, 12 May 2017 11:09:46 GMT https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336007#M412094 sunny_talwar 2017-05-12T11:09:46Z Re: inconsistent number formats.....! https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336008#M412095 <HTML><HEAD></HEAD><BODY><P>I have already set number format for 2 decimal place but it is not working properly.</P><P>it will show sometime in decimal and sometime not.</P></BODY></HTML> Fri, 12 May 2017 11:30:18 GMT https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336008#M412095 infosense_devel 2017-05-12T11:30:18Z Re: inconsistent number formats.....! https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336009#M412096 <HTML><HEAD></HEAD><BODY><P>did you look at static step part from the post?</P></BODY></HTML> Fri, 12 May 2017 11:36:40 GMT https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336009#M412096 sunny_talwar 2017-05-12T11:36:40Z Re: inconsistent number formats.....! https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336010#M412097 <HTML><HEAD></HEAD><BODY><P>Yes I have tested with different value in static step but it is working in some cases and not in all.</P><P>I know it is totally dependent on data but any other solution???</P></BODY></HTML> Fri, 12 May 2017 11:46:17 GMT https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336010#M412097 infosense_devel 2017-05-12T11:46:17Z Re: inconsistent number formats.....! https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336011#M412098 <HTML><HEAD></HEAD><BODY><P>Would you be able to replicate this issue in a sample document? I guess it will be easier to try out few things <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 12 May 2017 11:54:40 GMT https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336011#M412098 sunny_talwar 2017-05-12T11:54:40Z Re: inconsistent number formats.....! https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336012#M412099 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Another thought - did you try to format your expression with a num() function instead of using the number-tab?</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 12 May 2017 11:58:12 GMT https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336012#M412099 marcus_sommer 2017-05-12T11:58:12Z Re: inconsistent number formats.....! https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336013#M412100 <HTML><HEAD></HEAD><BODY><P>Apparently it isn't strictly dependent on data, rather on the layout and size of all sub-elements of your chart.</P><P></P><P>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?</P><P></P><P>It may be that QlikView switching back to the default dynamic label formatting cannot be avoided in some cases.</P></BODY></HTML> Fri, 12 May 2017 12:17:15 GMT https://community.qlik.com/t5/QlikView/inconsistent-number-formats/m-p/1336013#M412100 Peter_Cammaert 2017-05-12T12:17:15Z