Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
gfisch13
Contributor

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
Contributor II

Re: Compare Two fields in a single table

Try this expression

if (owner=bene, policynum)

and uncheck include null values

Regards,
Bhargav
4 Replies
bhargav_bhat
Contributor II

Re: Compare Two fields in a single table

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
Contributor

Re: Compare Two fields in a single table

Just the mismatches please.
Thank you!
bhargav_bhat
Contributor II

Re: Compare Two fields in a single table

Try this expression

if (owner=bene, policynum)

and uncheck include null values

Regards,
Bhargav
gfisch13
Contributor

Re: Compare Two fields in a single table

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