How to exclude the result of one view from another one? I would like to implement a discussion overview page which displays the hot topics  and latest topics, excluding the hot topics from the latest ones.


I have two displays in the same view, each of those operates on the same dataset (listing the same content type).
The difference between the two displays is the sort criteria only.


Is it possible to set up the display which generates the latest topics list to exclude hot topics? More generally: is it possible to exclude the results of one view from another without making a custom module?

I would like to get a general answer not involving offsets, because we'll probably face a situation where the sort criterias have to change. Most likely offsetting won't solve my issue there.

[Drupal 7 with Views 3.]
One thing that pops to mind, albeit dirty, is to use php in the argument and do:


views_get_view_result($name, $display_id = NULL)
Loop over resulting nids of your hot topics then explode them out separated by + 
set the argument to exclude these nids.


Not the cleanest solution as it leaves you with php in the DB but it would work.