topic Re: How to limit the decimals in Text Object in QlikView https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140254#M521689 <HTML><HEAD></HEAD><BODY><P>try like this </P><P></P><P>num('<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">43.539290780812','######0.00')</SPAN></P><P>or</P><P>num(field_name,<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">'######0.00'</SPAN>)</P></BODY></HTML> Fri, 13 May 2016 10:02:28 GMT avinashelite 2016-05-13T10:02:28Z How to limit the decimals in Text Object https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140250#M521685 <HTML><HEAD></HEAD><BODY><P>HI all</P><P></P><P><SPAN style="background-color: rgba(255, 255, 255, 0);">How to limit the decimals in Text Object</SPAN></P><P><SPAN style="background-color: rgba(255, 255, 255, 0);"><BR /></SPAN></P><P><SPAN style="background-color: rgba(255, 255, 255, 0);">i got 43.539290780812 for my calculation<BR /></SPAN></P><P>‌I need to show 43.53 in text object</P><P></P><P>Can any one help me to solve</P><P></P><P>thanks</P><P>AR UMAMAHESH</P></BODY></HTML> Fri, 13 May 2016 09:58:54 GMT https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140250#M521685 2016-05-13T09:58:54Z Re: How to limit the decimals in Text Object https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140251#M521686 <HTML><HEAD></HEAD><BODY><P>Use the Num() function</P><P></P><P><STRONG>=Num(YourExpression, '#,##0.00')</STRONG></P></BODY></HTML> Fri, 13 May 2016 10:00:45 GMT https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140251#M521686 sunny_talwar 2016-05-13T10:00:45Z Re: How to limit the decimals in Text Object https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140252#M521687 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>try this</P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">num(fieldname</SPAN><SPAN style="font-size: 8pt;">,'#.##') </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">fieldname - it can be an expression too</SPAN></P></BODY></HTML> Fri, 13 May 2016 10:01:59 GMT https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140252#M521687 ankit777 2016-05-13T10:01:59Z Re: How to limit the decimals in Text Object https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140253#M521688 <HTML><HEAD></HEAD><BODY><P>Or this to floor your value</P><P></P><P><STRONG>Floor('43.539290780812', 0.01)</STRONG></P></BODY></HTML> Fri, 13 May 2016 10:02:14 GMT https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140253#M521688 sunny_talwar 2016-05-13T10:02:14Z Re: How to limit the decimals in Text Object https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140254#M521689 <HTML><HEAD></HEAD><BODY><P>try like this </P><P></P><P>num('<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">43.539290780812','######0.00')</SPAN></P><P>or</P><P>num(field_name,<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">'######0.00'</SPAN>)</P></BODY></HTML> Fri, 13 May 2016 10:02:28 GMT https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140254#M521689 avinashelite 2016-05-13T10:02:28Z Re: How to limit the decimals in Text Object https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140255#M521690 <HTML><HEAD></HEAD><BODY><P><STRONG><EM>=floor(YourExpression, 0.01)</EM></STRONG></P></BODY></HTML> Fri, 13 May 2016 10:03:36 GMT https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140255#M521690 Kushal_Chawda 2016-05-13T10:03:36Z Re: How to limit the decimals in Text Object https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140256#M521691 <HTML><HEAD></HEAD><BODY><P class="">Thanks Sunny</P><P class="">It's working</P></BODY></HTML> Fri, 13 May 2016 10:16:50 GMT https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140256#M521691 2016-05-13T10:16:50Z Re: How to limit the decimals in Text Object https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140257#M521692 <HTML><HEAD></HEAD><BODY><P class="">Thank you very much you all</P><P class=""><BR /></P><P class="">Thanks,</P><P class="">AR UMAMAHESH</P></BODY></HTML> Fri, 13 May 2016 10:19:45 GMT https://community.qlik.com/t5/QlikView/How-to-limit-the-decimals-in-Text-Object/m-p/1140257#M521692 2016-05-13T10:19:45Z