How to write a code for subquery in Qliksense

[aatish12345]

Hi Everyone,

I have a SQL code, for example:

Select Column 1 from Table1 where

Column2  IN (select column3  from table 2)

I want to achieve this through qlik code.

Can someone help here plz...

Aatish

[abhijitnalekar]

Hi Atish,

You can achieve the same by using the where Exist script function.

Please go through with the below link for example.

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordF...

[jyothish8807 · Accepted solution]

Hi @aatish12345 :

May be like this:

Table1:

Load 

column3 

from table 2;

Table2:

Load

Column 1 from Table1 where exists (column3 ,Column2);

Drop table Table1;