Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Kashia1122
Contributor II
Contributor II

not in from SQL to QlikSense

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

 

Labels (1)
1 Reply
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.