topic Re: Select multiple values from 2 non-associated listboxes simultaneously in QlikView

Select multiple values from 2 non-associated listboxes simultaneously

sifatnabil — Tue, 08 Jul 2014 04:32:08 GMT

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?

Re: Select multiple values from 2 non-associated listboxes simultaneously

Tue, 08 Jul 2014 04:39:34 GMT

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

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

Thanks,

Ram

Re: Select multiple values from 2 non-associated listboxes simultaneously

sifatnabil — Tue, 08 Jul 2014 04:47:44 GMT

Nice one, thanks!

Re: Select multiple values from 2 non-associated listboxes simultaneously

sifatnabil — Tue, 08 Jul 2014 04:57:29 GMT

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.

Re: Select multiple values from 2 non-associated listboxes simultaneously

sifatnabil — Tue, 08 Jul 2014 05:10:44 GMT

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!

topic Re: Select *multiple* values from 2 non-associated listboxes simultaneously in QlikView

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

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

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

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

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

topic Re: Select multiple values from 2 non-associated listboxes simultaneously in QlikView

Select multiple values from 2 non-associated listboxes simultaneously

Re: Select multiple values from 2 non-associated listboxes simultaneously

Re: Select multiple values from 2 non-associated listboxes simultaneously

Re: Select multiple values from 2 non-associated listboxes simultaneously

Re: Select multiple values from 2 non-associated listboxes simultaneously