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.

       

      Example:

       

      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


      1242

      14851


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


      Please bear with me.


      Thanks!