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.
evgeniystuchalk
Not applicable

Where not Exists blowing my mind

Hello! I have this code:

LOAD *;

SQL SELECT *

FROM amo.companies

WHERE i_lastModified>=$(vLastUpdate) and i_lastModified<$(vNow)

Concatenate LOAD *

FROM [Lib://QVD (win-lng2sl4osbd_qlik.acc)/companies.qvd]

Where not Exists(i_companyID);

Inner Join SQL SELECT i_companyID FROM amo.companies;

If ScriptErrorCount = 0 then

store companies into [Lib://QVD (win-lng2sl4osbd_qlik.acc)/companies.qvd] (qvd);

Let vLastUpdate = $(vNow);

End If

Problem in the red zone: when i'm trying to load this code, i have namless error:

778ebfc6fc.jpg

if Where Not Exist condition removed, all works fine. i_companyID - field in QVD file. It exists, correctl named, and have data in it. Whata wrong?

1 Solution

Accepted Solutions
evgeniystuchalk
Not applicable

Re: Where not Exists blowing my mind

OMG, im just forget to write (qvd) after path to qvd file

so, that is correct: FROM [Lib://QVD (win-lng2sl4osbd_qlik.acc)/companies.qvd] (qvd)

2 Replies
evgeniystuchalk
Not applicable

Re: Where not Exists blowing my mind

OMG, im just forget to write (qvd) after path to qvd file

so, that is correct: FROM [Lib://QVD (win-lng2sl4osbd_qlik.acc)/companies.qvd] (qvd)

sunny_talwar
Not applicable

Re: Where not Exists blowing my mind

Try adding (qvd) before Where statement

Concatenate LOAD *

FROM [Lib://QVD (win-lng2sl4osbd_qlik.acc)/companies.qvd]

(qvd)

Where not Exists(i_companyID);