Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

sifatnabil
Contributor III

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

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?

1 Solution

Accepted Solutions
Not applicable

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

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


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


Thanks,

Ram

4 Replies
Not applicable

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

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


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


Thanks,

Ram

sifatnabil
Contributor III

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

Nice one, thanks!

sifatnabil
Contributor III

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

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
Contributor III

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

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!

Community Browser