topic Re: select multiple fields using trigger / action in QlikView

select multiple fields using trigger / action

regowins — Wed, 08 Jan 2014 22:21:22 GMT

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!

Re: select multiple fields using trigger / action

MayilVahanan — Wed, 08 Jan 2014 22:28:45 GMT

Try like this

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

Re: select multiple fields using trigger / action

swuehl — Wed, 08 Jan 2014 22:31:55 GMT

This thread discusses some different approaches:

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

Re: select multiple fields using trigger / action

regowins — Wed, 08 Jan 2014 22:40:44 GMT

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

Re: select multiple fields using trigger / action

MayilVahanan — Wed, 08 Jan 2014 22:46:56 GMT

Can you provide a sample?

Re: select multiple fields using trigger / action

iktrayanov — Wed, 08 Jan 2014 22:51:27 GMT

The search string for your select in field action should be

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

Re: Re: select multiple fields using trigger / action

regowins — Wed, 08 Jan 2014 23:04:01 GMT

Thanks for help. Here is a sample

Re: Re: Re: select multiple fields using trigger / action

MayilVahanan — Wed, 08 Jan 2014 23:19:53 GMT

Try like this

PFA

Re: select multiple fields using trigger / action

regowins — Thu, 09 Jan 2014 00:22:29 GMT

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.

Re: select multiple fields using trigger / action

Thu, 10 Jul 2014 09:18:05 GMT

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!

Re: Re: select multiple fields using trigger / action

regowins — Thu, 10 Jul 2014 14:02:04 GMT

Hi Erik,

Here is another example. Hope it helps. -Ash

Re: Re: select multiple fields using trigger / action

Fri, 11 Jul 2014 06:21:40 GMT

simply PERFECT!

thank you ashwin!