topic expression help in QlikView https://community.qlik.com/t5/QlikView/expression-help/m-p/555761#M1124477 <HTML><HEAD></HEAD><BODY><P><BR /><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">Hi,</SPAN></P><P></P><P><SPAN style="font-size: 12pt; font-family: calibri, verdana, arial, sans-serif;">This will probably be simple but we have the following expression:</SPAN></P><P></P><P></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff;">avg</SPAN>(<SPAN style="color: #800000;">[Tenancy_Length_Days]</SPAN>)/365 </SPAN></P><P></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">It works; however, currently provides a number with about 10 decimal points (8.4483735659404). </SPAN><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Can yone advise how to add to this so it only shows 2 decimal points? </SPAN></SPAN></P><P> </P><P> </P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">Cheers</SPAN></P><P> </P><P> </P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"><SPAN style="font-size: 12pt;">Chris</SPAN></SPAN></P></BODY></HTML> Mon, 06 Jan 2014 09:25:15 GMT 2014-01-06T09:25:15Z expression help https://community.qlik.com/t5/QlikView/expression-help/m-p/555761#M1124477 <HTML><HEAD></HEAD><BODY><P><BR /><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">Hi,</SPAN></P><P></P><P><SPAN style="font-size: 12pt; font-family: calibri, verdana, arial, sans-serif;">This will probably be simple but we have the following expression:</SPAN></P><P></P><P></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff;">avg</SPAN>(<SPAN style="color: #800000;">[Tenancy_Length_Days]</SPAN>)/365 </SPAN></P><P></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">It works; however, currently provides a number with about 10 decimal points (8.4483735659404). </SPAN><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Can yone advise how to add to this so it only shows 2 decimal points? </SPAN></SPAN></P><P> </P><P> </P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">Cheers</SPAN></P><P> </P><P> </P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"><SPAN style="font-size: 12pt;">Chris</SPAN></SPAN></P></BODY></HTML> Mon, 06 Jan 2014 09:25:15 GMT https://community.qlik.com/t5/QlikView/expression-help/m-p/555761#M1124477 2014-01-06T09:25:15Z Re: expression help https://community.qlik.com/t5/QlikView/expression-help/m-p/555762#M1124478 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 16px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">round ( avg</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 16px;">(</SPAN><SPAN style="font-size: 16px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">[Tenancy_Length_Days]</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 16px;">)/365 , 0.01 )</SPAN></P></BODY></HTML> Mon, 06 Jan 2014 09:26:44 GMT https://community.qlik.com/t5/QlikView/expression-help/m-p/555762#M1124478 Anonymous 2014-01-06T09:26:44Z Re: expression help https://community.qlik.com/t5/QlikView/expression-help/m-p/555763#M1124479 <HTML><HEAD></HEAD><BODY><P>Just go to the Number Tab in properties and set Fixed to Decimals =2</P></BODY></HTML> Mon, 06 Jan 2014 09:28:40 GMT https://community.qlik.com/t5/QlikView/expression-help/m-p/555763#M1124479 sujeetsingh 2014-01-06T09:28:40Z Re: expression help https://community.qlik.com/t5/QlikView/expression-help/m-p/555764#M1124480 <HTML><HEAD></HEAD><BODY><P>Go to properties and then to number tab.Select the expression and then in number expression setting select fixed to and change the number to 2.</P><P></P><P>This will work.</P><P></P><P>If it is not a chart, use round functin as mentioned by Bill.</P></BODY></HTML> Mon, 06 Jan 2014 09:29:37 GMT https://community.qlik.com/t5/QlikView/expression-help/m-p/555764#M1124480 2014-01-06T09:29:37Z Re: expression help https://community.qlik.com/t5/QlikView/expression-help/m-p/555765#M1124481 <HTML><HEAD></HEAD><BODY><P>NUM(AVG([Tenancy_Length_Days])/365,'#,##0.00')</P></BODY></HTML> Mon, 06 Jan 2014 09:31:14 GMT https://community.qlik.com/t5/QlikView/expression-help/m-p/555765#M1124481 rustyfishbones 2014-01-06T09:31:14Z Re: expression help https://community.qlik.com/t5/QlikView/expression-help/m-p/555766#M1124482 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>Go to Properties of the Chart&gt;&gt;Number Tab&gt;&gt;Select the expression&gt;&gt;Number Format settings 'Fixed To' : 2 decimals</P></BODY></HTML> Mon, 06 Jan 2014 09:31:32 GMT https://community.qlik.com/t5/QlikView/expression-help/m-p/555766#M1124482 dmohanty 2014-01-06T09:31:32Z