topic Re: How to search a field value in other fields , based on selection in a different field ? in QlikView

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

alina_qlik — Thu, 03 Jun 2021 05:54:33 GMT

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 .

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

Qlik1_User1 — Thu, 03 Jun 2021 07:20:14 GMT

@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.

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

alina_qlik — Fri, 04 Jun 2021 06:19:09 GMT

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 !!

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

Qlik1_User1 — Fri, 04 Jun 2021 07:49:14 GMT

@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.