Help in a script

kusatvaky — Wed, 01 Mar 2023 10:52:42 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

ajaykakkar93 — Thu, 02 Mar 2023 05:17:05 GMT

You can flag using Applymap, below is a simple example

[ApplyMap T1]:
mapping // important to add
Load * Inline [
ApplyMap Sales Rep Name,ApplyMap Sales Rep Salary
Amit,25000
Sukhi,21000
Ankit,20000
];

[ApplyMap T2]:
Load *,
ApplyMap('ApplyMap T1', [ApplyMap Sales Rep Name],'NA') As [ApplyMap Sales Rep Salary];
Load * Inline [
ApplyMap Sales Rep Name,ApplyMap Sales Rep Role
Amit,B2B
Darshan,340B
Sukhi,B2B
Ankit,340B
];

In your case, you need to create a key in both tables & use applymap to get the value

If the value will match per key then the value will be added into your new column or it will give you NA(not assigned)

topic Re: Help in a script in QlikView

Help in a script

Re: Help in a script