not in from SQL to QlikSense

[Kashia1122]

Hello,

I hope someone will be able to help me.

I need help on writing SQL to a script in QLIK Sense.

I have a problem with "where":

Select

A,

B,

C,

D,

E,

F

From table_1 AS Tab1

Join table_2 as Tab2 ON  Tab1.A = Tab2.B

Join table_3 as Tab3 ON Tab2.C = Tab3.D

Where E not in (Select F from table_4 where G <>0) aa

[vinieme12]

You can use your existing SQL as-is in Qliksense if you are connecting to the database for this

TableName:

SQL Select  xxxyourquery from w ;

To reduce the data you can use   Exists()  or Inner Keep  or Inner Join