topic Set Fields from button in QlikView

Set Fields from button

danosoft — Tue, 17 Jul 2018 09:21:50 GMT

Hi i have my field MESEIN in a listbox, when i click a button i want to set the same values in MESEOUT

i put action in the button setting: =GetFieldSelections(MESEIN) for MESEOUT i see if i choose only 1 value it work right, but if i choose more values in my MESEIN it not work... why?

Thanks

Re: Set Fields from button

lironbaram — Tue, 17 Jul 2018 09:29:15 GMT

use this expression

='(' & concat(distinct MESEIN,'|') & ')'

Re: Set Fields from button

YoussefBelloum — Tue, 17 Jul 2018 09:32:33 GMT

Hi,

you will need to use concat() function to concat multiple values.

like this:

='('&Concat(Distinct YOUR_FIELD,'|')&')'