Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
lucpechali
Partner
Partner

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
Partner
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