topic Re: Logical condition in QlikView

Logical condition

dhavalmvyas — Fri, 15 Jan 2021 08:49:46 GMT

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.

Re: Logical condition

MayilVahanan — Fri, 15 Jan 2021 09:22:46 GMT

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;

Re: Logical condition

dhavalmvyas — Fri, 15 Jan 2021 09:51:28 GMT

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.

Re: Logical condition

dhavalmvyas — Fri, 15 Jan 2021 09:54:08 GMT

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

Re: Logical condition

MayilVahanan — Fri, 15 Jan 2021 10:52:45 GMT

Hi @dhavalmvyas

What is ur expected results?