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: 
flygstolen_fred
Creator
Creator

Conditions over multiple rows

Hi,

I have two tables and I wanna have a list of all orders that contain 2 specific products, in this case I wanna have all orders that bought both a phone (175) and a headset (189). Any ideas how to solve this in a easy way? Thanks

Table Order:

OrderIdTotalMisc
1001500Misc1
1002300Misc2

Table Product:

OrderIdProductIdNamePrice
1001175Phone400
1001189Headset100
1002554Charger300
11 Replies
swuehl
MVP
MVP

There were some parenthesis misplaced:

=aggr( Only( {<OrderId = p({<ProductId = {175}>}) * p({<ProductId = {189}>})>} OrderId), OrderId)

flygstolen_fred
Creator
Creator
Author

Thanks swuehl, It works like a charm.