Select *multiple* values from 2 non-associated listboxes simultaneously

[sifatnabil]

Hi,

This question is very similar to the one posted here: http://community.qlik.com/thread/124060

But this time, how can the same multiple values be selected from 2 non-associated listboxes? Select in Field seems to only work for 1 selected value. If I select multiple, the trigger no longer works. Does something like Concat() need to be used?

[#2 · Accepted solution]

you have to try like this. Multiple selection will work then.

='(' & GetFieldSelections(<Your field>, '|') & ')'

Thanks,

Ram

[sifatnabil]

Nice one, thanks!

[sifatnabil]

Hi Ram,

For some reason when I select several values in the first listbox, only the excluded values are being selected in the 2nd listbox. I evaluated the expression that you provided and it returns "(NOT 27/6|4/7|11/7)". Is there a way to remove the NOT? It's only showing up when I select many values.

[sifatnabil]

I figured it out. Set the max values variable in GetFieldSelections() to a high number like 100,000:

fieldname [, valuesep [, maxvalues=6 ]])

Valuesep is the delimiter between selected

Maxvalues is the highest number of individual values that will be displayed before...

Thanks!