Hi Juan,
Attached you will find and example.
In it you have an example with the fields actor and film.
Qlikview's default behavior is to show all the movies that they both worked in but not strictly together.
If we want to know which actors worked together in a movie we must create create a table with distinct records between actors and movies, the field ANDACTOR will be enabled to run in AND MODE.
In the example if you select Tom Cruise and Brad Pitt in the Actor listbox you will find all movies each actor worked, if select them in the ANDActor list box you will find the movies that they worked together.
Let me know if this helps.
Kind regards,
