topic Compare Two fields in a single table in QlikView

Compare Two fields in a single table

gfisch13 — Sat, 16 Nov 2024 04:04:02 GMT

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.

Re: Compare Two fields in a single table

bhargav_bhat — Sat, 23 Mar 2019 13:56:39 GMT

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

Re: Compare Two fields in a single table

gfisch13 — Sat, 23 Mar 2019 14:12:48 GMT

Just the mismatches please.
Thank you!

Re: Compare Two fields in a single table

bhargav_bhat — Sat, 23 Mar 2019 14:20:18 GMT

Try this expression

if (owner=bene, policynum)

and uncheck include null values

Regards,
Bhargav

Re: Compare Two fields in a single table

gfisch13 — Mon, 25 Mar 2019 08:02:57 GMT

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