List available selection options?

[#1]

I have a sheet with several list boxes.  Visually I can see when I select a value in one box, how it impacts another box (unavailable options are greyed out).

Is there a way to determine the available options for a given field based on the selections placed on other fields?

I've used triggers to assign filters based on identical but differently named fields (using GetFieldSelections) but now would like to determine what options are available for a given field based on other filters being set.

Is there a way to do this?

Thank you.

[sebastiandperei]

Qlikview shows the non-referenced data with gray background.

If you don't want to see the non-referenced values, use the Manish solution. (also, mark as useful answer, at least!!)

Obviously, all of these solutions works good ONLY IF YOUR DATA IS WELL RELATED BETWEEN THEM.

Please, send a reduced copy.