Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
YekinKebo
Contributor
Contributor

Help in a script

Hello everyone, Im a begineer in qlikview. I have 2 tables, in the table 1 I have Policy ID and two different endorsement IDs, in the other table I have Policy ID and just one endorsement ID. How can I search for the policies that are in the table 1 but aren’t in the table 2. Using the combinations of Policy and enforsement.

Thanks!!

3 Replies
stevejoyce
Creator
Creator

It may depend on how you want to use the resulting set.  But 1 option is to use where exists.  see below for an example

 


table2:
load *
//create composite key
,policyID & table2.endorsementID as Key;

load * inline [
policyID, table2.endorsementID
1, 100
2, 100
]
;


table1:
load * inline [
policyID, table1.endorsementID
1, 100
1, 200

]
;


table1_NOT_table2:
noconcatenate load *
resident table1
where not exists (Key, policyID & table1.endorsementID)
;

 

Chip_Matejowsky
Support
Support

@YekinKebo
I moved this thread to the QlikView App Development section.

 

Best Regards

Sr. Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!
MarcoWedel

Hi,

I guess you are looking for a front end solution?

Can you please post some sample data of both tables including only the relevant ID fields?

thanks

Marco