Help Needed: How to select a calculated field automatically?

[#1]

This is an extension of my question in http://community.qlik.com/message/378149#378149.

What I am trying to do is have a "calculated" field automatically selected when a fixed field is choosen. For example, if a user select Dim_01 = AA, then Calculated Field = "Top' automatically (see attached). I have been trying to do this via load script and variable, but proven unsuccessful, and most likely I am approaching this in a wrong way.

That sais, any suggestion/help will be much appreciated. Thank you.

[tresB]

Hi,

tried an alternative, please try with the following search string:

='('&Concat(distinct aggr(if(rank(sum(M1)) <=3,ID),ID),'|')&')'

Note: Selection originally takes place only in the fields created in the script.

PFA

[#3]

Thank you, I will give it a try.