Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gfisch13
Creator II
Creator II

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 Reply
Channa
Specialist III
Specialist III

=if(bene<> owner,age) as ur AGE and 

deselect Include null values check box

Channa