Only show equal values of different fields

[#1]

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!

[robert_mika]

t1:

load * Inline

[

FIELD A     ,FIELD B

1242             ,1242

14851            ,14851

185              , 165

1891             , 122

18454            , 151

]

;

NoConcatenate

t2:

load 

[FIELD A] AS match

Resident t1

Where [FIELD A] =[FIELD B]

[maxgro]

t1:

load

  [FIELD A],

  if([FIELD A]=[FIELD B],[FIELD B]) as [FIELD B],

  if(match([FIELD A],[FIELD B]),[FIELD B]) as [FIELD BB]

Inline

[

FIELD A     ,FIELD B

1242             ,1242

14851            ,14851

185              , 165

1891             , 122

18454            , 151

]

;

[#4]

Please take a look at the attached file.

Thanks