How often a secondary product is purchased based off primary product selection Qlik

[Stdar]

Hello, 

I have seen a few questions similar to this but nothing exactly what I am looking for....

I have a few hundred lines of receipt data, each receipt has got a unique receipt ID, Date, quantity, product ID, price.

I would like to select from a list of product ID to show me what the most popular product bought with my selection, a top 5 or 10 perhaps.

anyone provide any direction? 

[rwunderlich]

Something like:

rank(sum({<ProductName=,OrderID=P(OrderID)>}LineSalesAmount)) < 6

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[Stdar]

thank you for this, one question... LineSalesAmount is that a variable in my data or is that a function?

[rwunderlich]

LineSalesAmount is a field in my data model.