Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

OR operator in QLIKVIEW data

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

2 Replies
Not applicable

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



Not applicable

Hello,

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

Overviews via several basic pivot tables.

Greetings,

Piet