Discussion board where members can get started with Qlik Sense.
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]
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.
load * Inline
FIELD A ,FIELD B
185 , 165
1891 , 122
18454 , 151
[FIELD A] AS match
Where [FIELD A] =[FIELD B]
if([FIELD A]=[FIELD B],[FIELD B]) as [FIELD B],
if(match([FIELD A],[FIELD B]),[FIELD B]) as [FIELD BB]
Please take a look at the attached file.