If Match replace

[raZor]

Hi Qlikers,

ColA, ColB, ColC,Result

A, B, B,A

B,B,C,C

C,A,C,C

D,D,A,A

Here if colA value is exactly same as ColB then in result take ColC as result

and if ColA not exactly same as ColB then take ColA as result

Regards,

[steeefan]

In the script editor: If(ColA = ColB, ColC, ColA) AS Result

If it should be chart expression, omit AS RESULT.

[raZor]

Will this work? If(match(ColA, ColB),ColC,ColA) on front end, I can not use in script.

Thanks in Advance 

[steeefan · Accepted solution]

Yes, that will work. Same as the expression I posted above, just omit AS Result:

• If(ColA = ColB, ColC, ColA)
• If(match(ColA, ColB),ColC,ColA)