topic OR operator in QLIKVIEW data in QlikView

OR operator in QLIKVIEW data

Mon, 22 Mar 2010 15:30:19 GMT

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

Mon, 22 Mar 2010 17:14:38 GMT

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';

Mon, 22 Mar 2010 18:21:21 GMT

Hello,

In attach an option with straight load of the 3 tables;

Overviews via several basic pivot tables.

Greetings,

Piet