3 Replies Latest reply: Apr 14, 2015 6:04 PM by Ajay Krishnan Prabhakaran RSS

    Only show equal values of different fields

      Hi guys,


      I'm new to Qlik and are using Qlik Sense.


      I was wondering how I can do a check for duplicates or equal values of two different fields.




      I have [FIELD A] and [FIELD B]


      [FIELD A]     [FIELD B]

      1242             1242

      14851            14851

      185               165

      1891              122

      18454             151

      Now I would like to return the equal values in [FIELD B] wich is



      I already tried: IF(MATCH([FIELD A], [FIELD B]),[FIELD B]) this doesn't work.

      Please bear with me.