Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

Where not Exists()

Here's a script I don't quite understand:

LOAD

    .....

    PostalCode as PostCode,

    .....

Resident Customer

Where not Exists(PostCode,PostalCode);


What is the use of Where not Exists(PostCode,PostalCode)?


Thanks for help!

2 Replies
ogster1974
Honored Contributor II

Re: Where not Exists()

YoussefBelloum
Esteemed Contributor

Re: Where not Exists()

after you understand the Exist function and in addition to the information described on the link above, you can replace your script by this:

LOAD

    .....

    PostalCode as PostCode,

    .....

Resident Customer

Where not Exists(PostCode);