5 Replies Latest reply: Nov 1, 2016 1:31 PM by Mario Ma RSS

    Qlik Sense  if condition with decimal weird behavior

    Mario Ma

      Hi all,

       

      I have little transformation on my app very simple which works againg  Home_Flag  = 1 or 0 (numeric) and I noticed that it works strangely if I use this expression:

      if(Home_Flag = 0,'No','Yes')  putting Yes for some data where Home_Flag = 0

      it happening while working on big dataset (500K+ rows).

      I fixed this by using:

      if(Home_Flag > 0,'Yes','No')


      Not sure what is wrong with first one, I DID played with quotes around "0" and it doesn't make any diff.  I used it to add column in my simple table in Q Sense.


      Thanks

      M