Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
mhmmd_srf
Not applicable

Using Not Exist

Hi All,

I want to delete from qvd for few Units. I have created Inline load and used that in Not Exists function. Below is my code:

UnitDelete:

Load * Inline

[DelUnit,

10,

100

];

Transaction:

LOAD

    CUSTOMER,

    "ABC #",

    "Invoice #",

    "Invoice Qty",

    "Invoice Type",

    "Total Extended Cost",

    Units,

   "Customer Group"

FROM [lib://QVDs/Transactions_01_09132016.qvd](qvd)

where Units not Exists (DelUnit,Units) ;

But I am getting error. Could you please help me on this.

Thanks in advance for your help.

Regards,

Sarif

1 Solution

Accepted Solutions
MindaugasBacius
Not applicable

Re: Using Not Exist

Remove Units:

where Units not Exists (DelUnit,Units) ;

4 Replies
nareshguntur
Not applicable

Re: Using Not Exist

Syntax error.

Use this

where not Exists (DelUnit,Units)



Cheers,

Naresh

robert_mika
Not applicable

Re: Using Not Exist

What is your error?

MindaugasBacius
Not applicable

Re: Using Not Exist

Remove Units:

where Units not Exists (DelUnit,Units) ;

mhmmd_srf
Not applicable

Re: Using Not Exist

Hi Robert,

It is Garbage error after statement.