If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Below script result show as;
But i need to see this, how can i join these two tables?
My Script is;
Table a:LoadLocation, Product, Orderx, a, 100y, b, 200Table b:LoadLocation, Product, Salesx, a, 90y, b, 210z, b, 50
I think this should work:
Load Location, Product, Order
LEFT JOIN (TableA)
Load Location, Product, sum(Sales) as Sales
Group by Location,Product;
View solution in original post