Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
@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.
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 !!
@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.