Discussion Board for collaboration related to QlikView App Development.
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?
RESIDENT Table where Code = 'X' or ProductType = 'Y';
In attach an option with straight load of the 3 tables;
Overviews via several basic pivot tables.