Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Obsyky
Contributor III
Contributor III

Operator = that does not return the correct information

Hello,

When I want to test a quality, I don’t get all the information back.
In I make an uneven quality, it returns to me the values whose quality I want to test.

X <> Y :

Obsyky_0-1648630383916.png

 

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

You shouldn't use the equals sign to test on floats. See https://community.qlik.com/t5/Qlik-Design-Blog/Rounding-Errors/ba-p/1468808

What you could do, is the following:
     fAbs(X-Y) < 0.0000001
or something similar.

View solution in original post

2 Replies
hic
Former Employee
Former Employee

You shouldn't use the equals sign to test on floats. See https://community.qlik.com/t5/Qlik-Design-Blog/Rounding-Errors/ba-p/1468808

What you could do, is the following:
     fAbs(X-Y) < 0.0000001
or something similar.

Obsyky
Contributor III
Contributor III
Author

Oh ! Thanks !