Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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
Highlighted
Not applicable

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


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


Thanks,

Ram

View solution in original post

4 Replies
Highlighted
Not applicable

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


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


Thanks,

Ram

View solution in original post

Highlighted
Specialist
Specialist

Nice one, thanks!

Highlighted
Specialist
Specialist

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.

Highlighted
Specialist
Specialist

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!