Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lucpechali
Partner - Contributor III
Partner - Contributor III

Bug QlikView & QlikSense !?

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

3 Replies
Frank_Hartmann
Master II
Master II

i guess the ratio is treated by QV as a string. you can also do like this:

=if($(=70/100)=0.7,'True','False')

Miguel_Angel_Baeyens

What Qlik Support has told you?

lucpechali
Partner - Contributor III
Partner - Contributor III
Author

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