Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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!

3 Replies

Re: Only show equal values of different fields

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]

14-Apr-15 4-30-26 PM.jpg

MVP
MVP

Re: Only show equal values of different fields

1.png


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

]

;

Not applicable

Re: Only show equal values of different fields

Please take a look at the attached file.

Thanks