Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

comparing two column

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
AZ
BB
CX
DY
EE

Regards,

Pooja

1 Solution

Accepted Solutions
sunny_talwar

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')

View solution in original post

3 Replies
sunny_talwar

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')

Not applicable
Author

Hi Sunny,

Thanks again for helping me  with a right solution.


Regards,


Pooja

sunny_talwar

Not a problem