Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

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
Partner
Partner

Remove Units:

where Units not Exists (DelUnit,Units) ;

View solution in original post

4 Replies
NareshGuntur
Partner
Partner

Syntax error.

Use this

where not Exists (DelUnit,Units)



Cheers,

Naresh

robert_mika

What is your error?

MindaugasBacius
Partner
Partner

Remove Units:

where Units not Exists (DelUnit,Units) ;

View solution in original post

mhmmd_srf
Creator II
Creator II
Author

Hi Robert,

It is Garbage error after statement.