topic Re: Help Needed: How to select a calculated field automatically? in QlikView

Help Needed: How to select a calculated field automatically?

Wed, 14 Aug 2013 01:37:20 GMT

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.

Re: Help Needed: How to select a calculated field automatically?

tresB — Wed, 14 Aug 2013 05:32:50 GMT

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

Re: Help Needed: How to select a calculated field automatically?

Wed, 14 Aug 2013 08:22:26 GMT

Thank you, I will give it a try.