7 Replies Latest reply: Mar 21, 2017 1:02 PM by Kevin McKeown RSS

    Comparing floats in QlikSense expressions not working

    Kevin McKeown

      I've come across this issue multiple times, but am unable to find any troubleshooting methods online.

       

      Example:

      field A is a numeric(18,2) data type

       

      For this example, A is equal to 0.82

       

      if(A>0,'True','False') will always return False

      if(A>0.00,'True','False') will always return False

      if(A<0.00,'True','False') will always return False


      For whatever reason, every comparison evaluation I do on floats returns False. Has anyone discovered a workaround for this?