Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Labras14
Contributor II
Contributor II

Exists subquery in qlik sense

 I want to find the same query but in qlik sense. how to do?

select CustomerID, CompanyName
from customers as a
where exists
(
   
select * from orders as b
   
where a.CustomerID = b.CustomerID
   
and ShipCountry = 'UK'
);

1 Solution

Accepted Solutions
Kushal_Chawda

@Labras14  First you need to create QVDs for both tables. Then use those QVDs to build logic in Qlik 

 

Orders:
LOAD distinct CustomerID
FROM Orders.QVD
where ShipCountry ='UK';

Left join(Orders)
LOAD CustomerID,
     CompanyName
FROM Customers.QVD;

 

View solution in original post

3 Replies
Kushal_Chawda

@Labras14  First you need to create QVDs for both tables. Then use those QVDs to build logic in Qlik 

 

Orders:
LOAD distinct CustomerID
FROM Orders.QVD
where ShipCountry ='UK';

Left join(Orders)
LOAD CustomerID,
     CompanyName
FROM Customers.QVD;

 

Labras14
Contributor II
Contributor II
Author

Thanks a loot!

You save my life in this moment!

Kushal_Chawda

@Labras14  Just changed the join type in previous post