Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gfisch13
Creator II
Creator II

Compare Two fields in a single table

Compare Field Values in a single table

Hi Folks..........

I'm working on a project that is loading data from two sources, one is a bank account file, the other is a policy master file.

In my script these two tables are linked by policy number.

In QV, I have created the table box (attached) that includes one field from the bank account file (Bene) and several others from the policy master file (policynum, owner, age)

I want to analyze values where the Bene last name and the owner last name are different.   I'm unsure how to present this.

Any help is appreciated.

Labels (3)
1 Solution

Accepted Solutions
bhargav_bhat
Creator II
Creator II

Try this expression

if (owner=bene, policynum)

and uncheck include null values

Regards,
Bhargav

View solution in original post

4 Replies
bhargav_bhat
Creator II
Creator II

Hi Fisch,

DO you want to have the only records in the table where there is a mismatch or you want to just highlight it keeping other records as well

Regards,
Bhargav
gfisch13
Creator II
Creator II
Author

Just the mismatches please.
Thank you!
bhargav_bhat
Creator II
Creator II

Try this expression

if (owner=bene, policynum)

and uncheck include null values

Regards,
Bhargav
gfisch13
Creator II
Creator II
Author

thanks for the input Bhargav, right on point. My data needs some cleansing which will further improve the results!!