How to make subquery in QV

[#1]

Hi,

I want Subquery code in qlikview is it possible to make in qlikview.

Below is the query :

select * from shipment where transport_mode='RAIL'

and Source_location_id not in (select location_id from region where region_id = 'RH_Mumbai')

Kindly help me in this

Regards,

Surekha

[#2]

Hi Macro,

As requested , Please find the small samples of qvd files for test result.

Request you to provide code for it.

Regards

[MarcoWedel]

Hi,

one possible solution using your sample data could be:

region:
LOAD Distinct LOCATION_ID
FROM [https://community.qlik.com/servlet/JiveServlet/download/1047306-227901/TESTREGION.xls] (txt, codepage is 1252, embedded labels, delimiter is '\t', msq)
Where REGION_ID = 'RH_MUMBAI';

shipment:
LOAD *
FROM [https://community.qlik.com/servlet/JiveServlet/download/1047306-227900/TESTSUB.xls] (txt, codepage is 1252, embedded labels, delimiter is '\t', msq)
Where TRANSPORT_MODE='RAIL' and not Exists (LOCATION_ID, SOURCE_LOCATION_ID); 

DROP Table region;

hope this helps

regards

Marco