Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Bug in frac() function

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Bug in frac() function

3 Replies
MVP
MVP

Re: Bug in frac() function

Re: Bug in frac() function

One way could be

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

Not applicable

Re: Bug in frac() function

Thanks swuehl!

Really helpful post!

... I guess I flunked my programming class

BR,

David