NOT IN Queries

rajeshvaswani77 — Wed, 22 Jun 2011 09:57:42 GMT

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

Re: NOT IN Queries

Wed, 22 Jun 2011 10:25:43 GMT

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