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.
@kazana Please see the below script that I have written in the Script Editor, please use the same idea to get the desired output. Also I have attached the Screen shot of the output, the Null values indicate the Policy ID's and Endorsement ID's present in table 1 but not in table 2.
