Discussion board where members can get started with QlikView.
Could someone please explain me the Exists function in Qlikview and SQL.
I'm bit confused in it.
Let us assume we have tables like below
Suppose if you want to load the ID in Table2 which are in Table1 then use below script
WHERE Exists(ID); // It will load only 1, 3,5 and filter out 6 because it is not available in Table1.
One more example:
If you dont want to load duplicate rows then use below script
WHERE NOT Exists(ID); // It will load 1 and 5 only once.
In this type of scenarios we use Exists in qlikview.
The purpose of Exists() is same in both QV and SQL, the only difference is the way of using it
FROM Table1 AS s
FROM Table2 b
WHERE a.ID = b.ID);
Hope this helps you.
View solution in original post
Thank you for your help Jagan.