topic Bug in frac() function in QlikView

Bug in frac() function

Thu, 13 Mar 2014 07:34:31 GMT

Hi,

When using the frac() - function in calculations I have noticed that it "misbehaves".

For example Frac(180.072) should return 0.072 but returns 0.072000000000003. This is quite an annoying problem, and it messes up a lot of my calculations which are dependent on the frac() - function.

Am I applying the frac() - function wrong, or is this a (.... known?) bug in QlikView? Is anyone else experiencing the same issue, and is there a hotfix for it?

I am currently running on QV 11.2 64-bit version.

Thanks,

David

Re: Bug in frac() function

swuehl — Thu, 13 Mar 2014 07:44:24 GMT

I don't think it's a bug, but floating point calculation. See also http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors

Re: Bug in frac() function

alexandros17 — Thu, 13 Mar 2014 07:57:20 GMT

One way could be

=Right(180.072,index(180.072,'.')+1)

Re: Bug in frac() function

Thu, 13 Mar 2014 09:00:53 GMT

Thanks swuehl!

Really helpful post!

... I guess I flunked my programming class

BR,

David