Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Author

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
Author

Hello,

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

Overviews via several basic pivot tables.

Greetings,

Piet