topic Re: How to get Whole and decimal part of a number? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-Whole-and-decimal-part-of-a-number/m-p/794477#M1025480 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> Check <A _jive_internal="true" data-containerid="2588" data-containertype="37" data-objectid="3471" data-objecttype="38" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors"><SPAN style="color: #3778c7;">http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors</SPAN></A></P></BODY></HTML> Thu, 26 Feb 2015 11:38:18 GMT Anonymous 2015-02-26T11:38:18Z How to get Whole and decimal part of a number? https://community.qlik.com/t5/QlikView/How-to-get-Whole-and-decimal-part-of-a-number/m-p/794474#M1025477 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have number say - 2.35</P><P></P><P>I need function to get 2 and another function to get 35</P><P></P><P>Regards,</P><P>Naeem </P></BODY></HTML> Thu, 26 Feb 2015 08:18:59 GMT https://community.qlik.com/t5/QlikView/How-to-get-Whole-and-decimal-part-of-a-number/m-p/794474#M1025477 2015-02-26T08:18:59Z Re: How to get Whole and decimal part of a number? https://community.qlik.com/t5/QlikView/How-to-get-Whole-and-decimal-part-of-a-number/m-p/794475#M1025478 <HTML><HEAD></HEAD><BODY><P>Hi Mohammed,</P><P>Use the Frac() function.</P><P>Miguel</P></BODY></HTML> Thu, 26 Feb 2015 11:30:53 GMT https://community.qlik.com/t5/QlikView/How-to-get-Whole-and-decimal-part-of-a-number/m-p/794475#M1025478 Miguel_Angel_Baeyens 2015-02-26T11:30:53Z Re: How to get Whole and decimal part of a number? https://community.qlik.com/t5/QlikView/How-to-get-Whole-and-decimal-part-of-a-number/m-p/794476#M1025479 <HTML><HEAD></HEAD><BODY><P>... and the Floor() function for the whole bit.</P></BODY></HTML> Thu, 26 Feb 2015 11:34:53 GMT https://community.qlik.com/t5/QlikView/How-to-get-Whole-and-decimal-part-of-a-number/m-p/794476#M1025479 Anonymous 2015-02-26T11:34:53Z Re: How to get Whole and decimal part of a number? https://community.qlik.com/t5/QlikView/How-to-get-Whole-and-decimal-part-of-a-number/m-p/794477#M1025480 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> Check <A _jive_internal="true" data-containerid="2588" data-containertype="37" data-objectid="3471" data-objecttype="38" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors"><SPAN style="color: #3778c7;">http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors</SPAN></A></P></BODY></HTML> Thu, 26 Feb 2015 11:38:18 GMT https://community.qlik.com/t5/QlikView/How-to-get-Whole-and-decimal-part-of-a-number/m-p/794477#M1025480 Anonymous 2015-02-26T11:38:18Z Re: How to get Whole and decimal part of a number? https://community.qlik.com/t5/QlikView/How-to-get-Whole-and-decimal-part-of-a-number/m-p/794478#M1025481 <HTML><HEAD></HEAD><BODY><P>=SubField(2.35,'.',1) //Returns 2</P><P></P><P>=SubField(2.35,'.',2) //Returns 35</P></BODY></HTML> Thu, 26 Feb 2015 11:42:40 GMT https://community.qlik.com/t5/QlikView/How-to-get-Whole-and-decimal-part-of-a-number/m-p/794478#M1025481 anbu1984 2015-02-26T11:42:40Z