topic Re: Trim the format in QlikView https://community.qlik.com/t5/QlikView/Trim-the-format/m-p/1352663#M842668 <HTML><HEAD></HEAD><BODY><P>I tried mid(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">float;#4.25000000000000</SPAN>,8) and that worked.</P><P></P><P>Thank you though <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 20 Apr 2017 17:38:51 GMT apthansh 2017-04-20T17:38:51Z Trim the format https://community.qlik.com/t5/QlikView/Trim-the-format/m-p/1352661#M842666 <HTML><HEAD></HEAD><BODY><P>How can I just get 4.25 from the below formatted number ?</P><P></P><P>float;#4.25000000000000</P><P></P><P>Thank you,</P><P>Supritha.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Trim-the-format/m-p/1352661#M842666 apthansh 2020-11-25T16:16:04Z Re: Trim the format https://community.qlik.com/t5/QlikView/Trim-the-format/m-p/1352662#M842667 <HTML><HEAD></HEAD><BODY><P><STRONG>May be this <BR /></STRONG></P><P><STRONG>num('4.250000000','0.00')</STRONG></P></BODY></HTML> Thu, 20 Apr 2017 17:18:23 GMT https://community.qlik.com/t5/QlikView/Trim-the-format/m-p/1352662#M842667 aarkay29 2017-04-20T17:18:23Z Re: Trim the format https://community.qlik.com/t5/QlikView/Trim-the-format/m-p/1352663#M842668 <HTML><HEAD></HEAD><BODY><P>I tried mid(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">float;#4.25000000000000</SPAN>,8) and that worked.</P><P></P><P>Thank you though <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 20 Apr 2017 17:38:51 GMT https://community.qlik.com/t5/QlikView/Trim-the-format/m-p/1352663#M842668 apthansh 2017-04-20T17:38:51Z