not in from SQL to QlikSense

Kashia1122 — Tue, 17 May 2022 17:17:22 GMT

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

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

Re: not in from SQL to QlikSense

vinieme12 — Tue, 17 May 2022 17:26:42 GMT

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