Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Thank you, I will give it a try.