topic Re: Select in Field - Multiple Values Question in QlikView

Select in Field - Multiple Values Question

Wed, 03 Oct 2012 16:46:21 GMT

When using a 'Select in field' trigger, if 1 or more values are selected in Field1 the desire is for Field2 to have the exact same selections everytime, how can this be done? (I just need field2 to always = field1)

If just use =Field1 as the Search String it works fine with 1 value, but isn't working when 2 or more values in Field1 are selected.

Thanks very much!

Richard

Re: Select in Field - Multiple Values Question

shree909 — Wed, 03 Oct 2012 17:05:03 GMT

Hi when u want to use multiple field values u have to concatenate and add them

for example if u have field values as fieldvalue1, fieldvalue 2....

then in select in field use 'fieldvalue1' |'fieldvalue2' if have spaces between the fieldvalues use ? like fieldvalue 2 , can be written as field?2?...

Re: Select in Field - Multiple Values Question

Wed, 03 Oct 2012 17:13:42 GMT

Not sure I follow, maybe a simple example will help me. If I have the following to fields with data:

Name1 Name2

Bob Bob

John John

Fred Fred

Etc.... Etc...

Currently I have Field Event Triggers on Name1, for all actions, the field Name2 set to Search String =Name1.

So if someone picks Bob in Name1, Bob will successfully also be selected in Name2.

However if someone picks Bob and Fred in Name1, then ALL the names stay selected in Name2. My need is to have only Bob and Fred also be select in Name2 to match what was select in Name1.

Hope this makes sense and THANK YOU VERY MUCH!

Re: Select in Field - Multiple Values Question

shree909 — Wed, 03 Oct 2012 17:23:59 GMT

i think u can use getfield selection(Name1) on first trigger andgetfield selection(nName 2) on second trigger

may be this can help you.. try this

Re: Select in Field - Multiple Values Question

Wed, 03 Oct 2012 18:31:30 GMT

I created a sample app (couldn't figure out how to upload it here or i would have) using getfieldselections on the trigger but still only works when 1 name is selected in name1value. If more then 1 is selected, then nothing is selected in name2value. Seems like this should be simple, what am i doing wrong?

Re: Select in Field - Multiple Values Question

Gysbert_Wassenaar — Wed, 03 Oct 2012 18:33:45 GMT

You can upload files in the advanced editor. Click on Use advanced editor when you create or edit a post.

Re: Select in Field - Multiple Values Question

Wed, 03 Oct 2012 18:34:18 GMT

Thanks. I saw that post. I am trying to avoid making it any more complex but maybe concat is the only answer. Although in that post the problem was really never completely solved so not even sure that concat is the answer.

Re: Select in Field - Multiple Values Question

Wed, 03 Oct 2012 18:37:39 GMT

Oh brother, i tried this and was looking above where the insert pictures etc. were, didn't look below! Well attached is the file, maybe this will make it easier!

Thanks much!!

Re: Select in Field - Multiple Values Question

Gysbert_Wassenaar — Wed, 03 Oct 2012 18:49:18 GMT

It's quite simple. See attached file. Just a simple concat expression instead of the getfieldselection

Re: Select in Field - Multiple Values Question

Wed, 03 Oct 2012 19:34:23 GMT

Perfect, thanks!

Re: Select in Field - Multiple Values Question

Tue, 26 Feb 2013 15:38:00 GMT

Hi Gysbert,

Do you know if it would be possible to apply this technique if you were using the same field but alternate states?

So if both listboxes were for Name1Value but two alternate states?

=concat({[State1]} Name1Value) and listing the trigger for "State2" does work, but not for multiple selections.

Any ideas?

Cheers,

Re: Select in Field - Multiple Values Question

Chernov — Tue, 14 Jan 2014 06:43:05 GMT

use double quotes, like this :

= '("' & concat({[State1]} Name1Value '" | "') & '')'

Re: Select in Field - Multiple Values Question

bhanukoppera7491 — Fri, 23 Apr 2021 09:51:43 GMT

Hi Gysbert,

I do have same requirement but the problem I have been facing is my values have spaces in between. when I have spaces it's not selecting the value. Can you help me out, how to handle this situation.

Thanks,