Logical condition

[dhavalmvyas]

Hi

I am new to Qlikview want your help for one calculated logic.

Nomineename of one Holdername should not be from rest of holdername.

For eg :

1> Suppose Nomineename against Aarti is Dhaval,so this record will be excluded because Dhaval is belonging to rest of Holdername for Aarti.

2>Suppose Nomineename against Manav is Suraj,so this record will be excluded because Suraj is belonging to rest of Holdername for Manav.

Please find attachment for your reference.

Kindly help me out on this.

Awaiting for response.

[MayilVahanan]

Hi @dhavalmvyas 

Try like below

TB01:
LOAD PolicyNumber,
Claimtype,
key,
Holdername,
Nomineename
FROM
[D:\Qlik\personnal\Sample (2).xlsx]
(ooxml, embedded labels, table is Document_TB01);

Temp:
Load Distinct Nomineename as Nm Resident TB01;

NoConcatenate
Final:
Load * Resident TB01 Where not Exists(Nm, Holdername);

DROP Table TB01, Temp;

[dhavalmvyas]

It's not working.

It excludes those Holdernames which apperas in both Holdername and Nomineename.

I want to exclude those Holdernames whoes Nomineename appears in both Holdername and Nomineename.

[dhavalmvyas]

For example,

1> Holdername Aarti and Manav will excluded because Nomineename apears against Aarti is Dhaval and Manav is Suraj and Dhaval and Suraj appears or present in both Holdername and Nomineename

[MayilVahanan]

Hi @dhavalmvyas 

What is ur expected results?