Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I've found something very strange on both QV and QS, whatever script or GUI :
Try this :
if(70/100=0.7,'True','False')
It's false ??? How ???
then test this :
if(60/100=0.6,'True','False')
It's true !!! Really ?
Is anyone already found this ?
The only way to make it true it's like this :
if(num#(70/100)=0.7,'True','False')
Any explications ?
Thx
i guess the ratio is treated by QV as a string. you can also do like this:
=if($(=70/100)=0.7,'True','False')
What Qlik Support has told you?
Hi ,
I've found this on the community. It seems to be the right answer
https://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors