topic Re: Frac() statement in QlikView https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455085#M169768 <HTML><HEAD></HEAD><BODY><P><BR />Hello,</P><P></P><P>frac(5.32) works but not frac(29.01).</P><P><IMG alt="2014-05-14_10h10_55.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/58806_2014-05-14_10h10_55.png" /></P><P>You have to round frac function to have the good result.</P><P>It's not a Qlikview bug but an interpretation of the rounded number. See my post above.</P></BODY></HTML> Wed, 14 May 2014 08:18:35 GMT 2014-05-14T08:18:35Z Frac() statement https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455079#M169762 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>frac(5.32) gives me 5.320000000000013 instead of 0.32.</P><P></P><P>can anyone explain to me why this is?</P><P></P><P>thanks</P></BODY></HTML> Wed, 20 Feb 2013 14:32:24 GMT https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455079#M169762 2013-02-20T14:32:24Z Re: Frac() statement https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455080#M169763 <HTML><HEAD></HEAD><BODY><P>What version are you on ? Qv 11 SR2 (64bit) returns 0.34</P><P>Jonathan</P></BODY></HTML> Thu, 21 Feb 2013 08:11:08 GMT https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455080#M169763 Anonymous 2013-02-21T08:11:08Z Re: Frac() statement https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455081#M169764 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am current on QV v11 SR2 (32bit). I am having other problems with it like the images don't display, so this might just be a version problem.</P><P></P><P>thanks </P></BODY></HTML> Thu, 21 Feb 2013 09:12:03 GMT https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455081#M169764 2013-02-21T09:12:03Z Re: Frac() statement https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455082#M169765 <HTML><HEAD></HEAD><BODY><P>I found with SR1 that after a reloading sheet objects didn't refresh as expected. Closing and then reopenning the document helped.</P><P>Not seen it on SR2 yet but see if a restart of the document helps.</P><P>Jonathan</P></BODY></HTML> Thu, 21 Feb 2013 10:13:36 GMT https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455082#M169765 Anonymous 2013-02-21T10:13:36Z Re: Frac() statement https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455083#M169766 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I don't think it's a bug, but floating point calculation. See also </SPAN><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors</A></P></BODY></HTML> Mon, 12 May 2014 08:44:59 GMT https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455083#M169766 2014-05-12T08:44:59Z Re: Frac() statement https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455084#M169767 <HTML><HEAD></HEAD><BODY><P>v11.2 SR5 shows the correct result..</P></BODY></HTML> Mon, 12 May 2014 08:59:49 GMT https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455084#M169767 rbecher 2014-05-12T08:59:49Z Re: Frac() statement https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455085#M169768 <HTML><HEAD></HEAD><BODY><P><BR />Hello,</P><P></P><P>frac(5.32) works but not frac(29.01).</P><P><IMG alt="2014-05-14_10h10_55.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/58806_2014-05-14_10h10_55.png" /></P><P>You have to round frac function to have the good result.</P><P>It's not a Qlikview bug but an interpretation of the rounded number. See my post above.</P></BODY></HTML> Wed, 14 May 2014 08:18:35 GMT https://community.qlik.com/t5/QlikView/Frac-statement/m-p/455085#M169768 2014-05-14T08:18:35Z