Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
regowins
Creator II
Creator II

select multiple fields using trigger / action

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!

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like this

PFA

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

11 Replies
MayilVahanan

Hi

Try like this

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
swuehl
MVP
MVP

This thread discusses some different approaches:

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

regowins
Creator II
Creator II
Author

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

MayilVahanan

Hi

Can you provide a sample?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
iktrayanov
Creator III
Creator III

The search string for your select in field action should be

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

regowins
Creator II
Creator II
Author

Thanks for help. Here is a sample

MayilVahanan

Hi

Try like this

PFA

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
regowins
Creator II
Creator II
Author

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. 

Not applicable

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!