topic Re: Help in a script in QlikView

Help in a script

YekinKebo — Wed, 08 Sep 2021 08:31:11 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

stevejoyce — Wed, 08 Sep 2021 10:36:23 GMT

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)
;

Re: Help in a script

Chip_Matejowsky — Wed, 08 Sep 2021 13:10:04 GMT

@YekinKebo
I moved this thread to the QlikView App Development section.

Best Regards

Re: Help in a script

MarcoWedel — Wed, 08 Sep 2021 19:30:57 GMT

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