Frac() statement

Report Inappropriate Content · ‎2013-02-20

Hi,

frac(5.32) gives me 5.320000000000013 instead of 0.32.

can anyone explain to me why this is?

thanks

Anonymous · ‎2013-02-21

What version are you on ? Qv 11 SR2 (64bit) returns 0.34

Jonathan

Report Inappropriate Content · ‎2013-02-21

Hi,

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.

thanks

Anonymous · ‎2013-02-21

I found with SR1 that after a reloading sheet objects didn't refresh as expected. Closing and then reopenning the document helped.

Not seen it on SR2 yet but see if a restart of the document helps.

Jonathan

Report Inappropriate Content · ‎2014-05-12

rbecher · ‎2014-05-12

v11.2 SR5 shows the correct result..

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

Report Inappropriate Content · ‎2014-05-14

Hello,

frac(5.32) works but not frac(29.01).

You have to round frac function to have the good result.

It's not a Qlikview bug but an interpretation of the rounded number. See my post above.