select multiple fields using trigger / action

[regowins]

Hi,

I want to select multiple names from the Mgr_Name field and select the same names in the Mgr_Name2 field in another chart via a trigger or any another method. I can get it to work with only  one name selected, but it wont work if I select multiple names.

Here is what I have done:

Created a variable   vName using the GetFieldSelections(mgr_Name)

Then  I created a field event trigger on the mgr_Name 'On select"   -> Select in field (Action)-> Mgr_Name2 (field) -> vName (search string)

Thanks for the help!

[MayilVahanan]

Hi

Try like this

='(*'&GetFieldSelections(mgr_Name,'*|*',100)&'*)'

[swuehl]

This thread discusses some different approaches:

http://community.qlik.com/thread/35764

[regowins]

Thanks but still not working. I put it in the variable vName and this is what I get.

[MayilVahanan]

Hi

Can you provide a sample?

[iktrayanov]

The search string for your select in field action should be

='('& replace(vName,',','|')&')'

[regowins]

Thanks for help. Here is a sample

[MayilVahanan · Accepted solution]

Hi

Try like this

PFA

[regowins]

Thanks for the help. it worked after I put  the code you gave  GetFieldSelections(Mgr_Name,'"|"',100) & '")' in both the 'select in field' & ' on change'  trigger. 

[#10]

Dear Ashwin, dear All,

I downloaded the file Mayil posted and indeed it is not working as expected.

I input the GetFieldSelections(Mgr_Name,'"|"',100) & '")' in both the 'select in field' & ' on change'  trigger. 

as indicated by you Ashwin and still indeed not working.

Could you please share a copy of the working file?
I also am facing a same issue and I need a solution !

thank you so much!