Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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

View solution in original post

11 Replies
MayilVahanan

Hi

Try like this

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

Thanks & Regards,
Mayil Vahanan R
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
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

View solution in original 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!