4 Replies Latest reply: Mar 24, 2016 6:15 AM by Sunny Talwar RSS

    Qlik Sense - If Expression giving different results

    Joel Lau

      Hi all,

       

      I have a dimension called VendorContactConflictFlag that only has the value 1 or is null.


      When using the expression below for records that do not have a value of 1 (i.e. null values), it gives the correct outcome of 0.


      IF(VendorContactConflictFlag=1,1,0)

       

      When using the second expression for the same records, it does not evaluate correctly and gives a value of 'Yes'.

       

      IF(VendorContactConflictFlag=1,'Yes','No')

       

      Would appreciate any help on why this is happening!

       

      Cheers,

      Joel