Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
asknyldz
Contributor III
Contributor III

Table Join

Hi All,

Below script result show as;

ProductOrderSales
a10090
b200210
-050

 

But i need to see this, how can i join these two tables?

ProductOrderSales
a10090
b200260

 

My Script is;

Table a:
Load
Location, Product, Order
x, a, 100
y, b, 200

Table b:
Load
Location, Product, Sales
x, a, 90
y, b, 210
z, b, 50

Labels (1)
1 Solution

Accepted Solutions
Nicole-Smith

I think this should work:

TableA:
Load Location, Product, Order
From YourTable1;

LEFT JOIN (TableA)
Load Location, Product, sum(Sales) as Sales
From YourTable2
Group by Location,Product;

View solution in original post

1 Reply
Nicole-Smith

I think this should work:

TableA:
Load Location, Product, Order
From YourTable1;

LEFT JOIN (TableA)
Load Location, Product, sum(Sales) as Sales
From YourTable2
Group by Location,Product;

View solution in original post