Exists function in Qlikview vs SQL

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

Could someone please explain me the Exists function in Qlikview and SQL.

I'm bit confused in it.

Thanks,

Ashok.

Re: Exists function in Qlikview vs SQL

jagan — Mon, 12 Dec 2016 05:42:08 GMT

Hi,

Qlikview:

Let us assume we have tables like below

Table1:

Table2:

Suppose if you want to load the ID in Table2 which are in Table1 then use below script

Table1:

LOAD

FROM Table1;

Table2:

LOAD

FROM Table2

WHERE Exists(ID); // It will load only 1, 3,5 and filter out 6 because it is not available in Table1.

One more example:

Table1:

If you dont want to load duplicate rows then use below script

Data:

LOAD

FROM Table1

WHERE NOT Exists(ID); // It will load 1 and 5 only once.

In this type of scenarios we use Exists in qlikview.

SQL Example:

The purpose of Exists() is same in both QV and SQL, the only difference is the way of using it

SELECT *

FROM Table1 AS s

WHERE EXISTS

(SELECT ID

FROM Table2 b

WHERE a.ID = b.ID);

Hope this helps you.

Regards,

Jagan.

Tue, 13 Dec 2016 04:40:03 GMT

Thank you for your help Jagan.