Sounds to me like a Basket Analysis problem. There are some examples on the community:
Re: Check if two certain products are sold together ?
Expression to know the mix product
but for this specific question:
- I would like to be able to select Movie A and then see what other movies have been watched by people who have watched Movie A. Preferably I would like to rank the other movies on number of views.
That's almost the definitio of a P function. You want to return the movies that have been seen by the people that have seen Movie A.
If you take a look at the last part of the Set Analysis help in QlikView you can find examples, for instance:
sum( {$<Customer = P({1<Product={‘Shoe’}>} Customer)>} Sales )
returns the sales for current selection, but only those customers that ever have bought the product ‘Shoe’. The element function P( ) here returns a list of possible customers; those that are implied by the selection ‘Shoe’ in the field Product.
Which is basically what you are looking for (but with viewers and movies).
Hope it helps.
Best regards.
.png "Former Employee"){kind=icon}