topic Format axis with two decimals in QlikView https://community.qlik.com/t5/QlikView/Format-axis-with-two-decimals/m-p/150032#M28132 <HTML><HEAD></HEAD><BODY><P>In case you didn't realize, you can never see the 0 on a logarithmic scale because it is infinitely far down the page.</P><P>Unfortunately, I don't know how to fomat the numbers on the Y axis. I once resorted to overlaying a text box. There is almost certainly an easier way.</P></BODY></HTML> Thu, 23 Jul 2009 02:27:11 GMT johnw 2009-07-23T02:27:11Z Format axis with two decimals https://community.qlik.com/t5/QlikView/Format-axis-with-two-decimals/m-p/150031#M28131 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am needing to show price, on the Y axis, but I cannot get the chart to show two decimals, only one. If I choose Log Scale for my expression, I lose the zero level. What i need is to preserve the zero AND show two decimals...thanks in advance for your help!</P><P></P></BODY></HTML> Wed, 22 Jul 2009 22:00:38 GMT https://community.qlik.com/t5/QlikView/Format-axis-with-two-decimals/m-p/150031#M28131 2009-07-22T22:00:38Z Format axis with two decimals https://community.qlik.com/t5/QlikView/Format-axis-with-two-decimals/m-p/150032#M28132 <HTML><HEAD></HEAD><BODY><P>In case you didn't realize, you can never see the 0 on a logarithmic scale because it is infinitely far down the page.</P><P>Unfortunately, I don't know how to fomat the numbers on the Y axis. I once resorted to overlaying a text box. There is almost certainly an easier way.</P></BODY></HTML> Thu, 23 Jul 2009 02:27:11 GMT https://community.qlik.com/t5/QlikView/Format-axis-with-two-decimals/m-p/150032#M28132 johnw 2009-07-23T02:27:11Z Format axis with two decimals https://community.qlik.com/t5/QlikView/Format-axis-with-two-decimals/m-p/150033#M28133 <HTML><HEAD></HEAD><BODY><P>There is currently no way to completely control the number formatting used for an axis, the format is based on the numberformat of the first expression to use that axis, but modified to fit the numbers to be shown.</P></BODY></HTML> Thu, 23 Jul 2009 15:45:29 GMT https://community.qlik.com/t5/QlikView/Format-axis-with-two-decimals/m-p/150033#M28133 kji 2009-07-23T15:45:29Z Format axis with two decimals https://community.qlik.com/t5/QlikView/Format-axis-with-two-decimals/m-p/150034#M28134 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P>have u tried to use <STRONG><EM>'round()'</EM></STRONG> function??</P></BODY></HTML> Thu, 23 Jul 2009 16:45:01 GMT https://community.qlik.com/t5/QlikView/Format-axis-with-two-decimals/m-p/150034#M28134 dolphin123 2009-07-23T16:45:01Z Format axis with two decimals https://community.qlik.com/t5/QlikView/Format-axis-with-two-decimals/m-p/150035#M28135 <HTML><HEAD></HEAD><BODY><P>You can change the interval value to 0.01 in the Axes tab of your chart ?</P><P></P></BODY></HTML> Thu, 23 Jul 2009 17:28:56 GMT https://community.qlik.com/t5/QlikView/Format-axis-with-two-decimals/m-p/150035#M28135 2009-07-23T17:28:56Z