NOT IN Queries

[rajeshvaswani77]

Hi All,

     We are creating Qlikview dashboards based on some existing queries. I find a Query like

Query NOT IN (Query)

How do i Iterpret this in QlikView to get similar results?

Thanks in advance,

Rajesh Vaswani

[#2 · Accepted solution]

You could do like below.

Step1: Load Data from Your Inner / Sub Query

Sql Select FieldA From TableA;

2nd Step : Load Data from Your Oter Quert and use Where Not Exists() function to do the job for you.

Load * where Not Exists(FieldA);

Sql Select * from TableB;

Hope this helps you.

- Sridhar