Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Specialist II
Specialist II

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

Principal 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