Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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 III
Creator III

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