How to search a field value in other fields , based on selection in a different field ?

[alina_qlik]

Hi There 

I have a requirement :

How to search a field value in other fields , based on selection in a different field ?

Example : Have a table with 5 columns like - Country , Geography , ZONES , Location , Rainfall .

If i have selected a field value Europe in Country column . Is there anyway by which this fieldvalue "Europe" can be daynamically searched in in the whole other table columns via search box . 
Just for example "Europe" as value do exist in Location column as well .

? Not sure if this is viable !!

Thank you all .

[Qlik1_User1]

@alina_qlik 
Try this in location dimension.
AGGR(ONLY({1<Country=P(Country)>}location),location)
Values that are associated with Europe will only be shown in Location filter.

[alina_qlik]

Thank you .

I guess this does not stand my requirement .

My requirement is , if any value is selected in any field then that value should dynamically be searched/copied
in search object box and hence should show results .

Hope this explains !!

[Qlik1_User1]

@alina_qlik 
Yes understood the requirement but that is not feasible it seems, so as an alternative solution you can try the shared expression and change it as per requirement.