topic Re: Help in a script in QlikView

Help in a script

HiroyuYulin — Mon, 26 Jan 2026 21:26:37 GMT

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!!

Re: Help in a script

MayilVahanan — Tue, 20 Apr 2021 06:52:14 GMT

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.