Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following data model
Table: Orders OrderLines Products
Fields: OrderId OrderId ProductCode
Code ProductCode ProductType
There is a relationship between Orders and OrderLines using OrderId and between OrderLines and Products using ProductCode
I want to be able to show counts etc where the Orders.Code = 'X' or Products.ProductType = 'Y' - can I do this in Qlikview?
Thanks
Table:
load
OrderId,
Code
FROM orders;
join
load
Orderid,
ProductCode
FROM OrderLInes;
join
load
ProductCode,
ProductType
FROM Products;
load
OrderId,
code,
ProductCode,
ProductType
RESIDENT Table where Code = 'X' or ProductType = 'Y';
Hello,
In attach an option with straight load of the 3 tables;
Overviews via several basic pivot tables.
Greetings,
Piet