Qlik Community

Ask a Question

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
HiroyuYulin
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!!

Labels (1)
1 Reply
MayilVahanan

Hi @HiroyuYulin 

Try with exists() function to find it. For ex:

Load PolicyId&'-'&EndorsementId as Key, * from table1;

Load If(not exists(Key, PolicyId&'-'&EndorsementId ), 1, 0) as Flag, * from table2;

In front end, if you select Flag -> 1, you can find how many policies with combination of endorsement not available in table 2.

Thanks & Regards,
Mayil Vahanan R