topic Re: comparing two column in QlikView

comparing two column

Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

Please let me know if any one can help me on the logic for the below.

I need to compare the two column values. If the values are match i need to put the message in text box " Yes there is a Matching Value " or "No Matching Value is there". It should work based on the user selection also. For ex. If user select any one record from field1 also the same condition ll work.

FIELD1	Field2
A	Z
B	B
C	X
D	Y
E	E

Regards,

Pooja

Re: comparing two column

sunny_talwar — Wed, 01 Jun 2016 16:57:23 GMT

May be like this:

=If(Sum(Aggr(If(Match(Field1, Field2), 1, 0), Field1, Field2)) > 0, 'Yes there is a Matching Value', 'No Matching Value is there')

Re: comparing two column

Wed, 01 Jun 2016 17:22:54 GMT

Hi Sunny,

Thanks again for helping me with a right solution.

Regards,

Pooja

Re: comparing two column

sunny_talwar — Wed, 01 Jun 2016 19:37:17 GMT

Not a problem