Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Mass selection in list box and dynamically filled exclusion list

Hello,

I am QlikView release 10 user/designer. I would like to select multiple product numbers copied from the clipboard and entered as a mass selection, while the list box either allows manual search and activation by picking individual numbers. This is not feasible in case of mass data available. So far I am using the workaround with the search function by activating ctrl+shft+'F' , selecting 'PRODUCTS' and entering a condition of the type "= like 'xyz' or like 'xzy' "aso from an Excel list. How can I allow a user to easily enter a list of products from copied from Excel into the clipboard and paste it into a list box? Else, for some cases we may need an exception table and exclude products that have been marked interactively in order to be excluded from further analysis. The result should either be saved or deleted until next use. So we need both the active dynamic mass selection + the dynamic exlusion of certain product numbers w/o interaction of any upload procedure.

Is this possible already?

Thanks for your help

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Mass selection in list box and dynamically filled exclusion list

Attached is an example (created by rebeccad) that allows you to paste a list of items in a text box to use as selection. You should be able to use the same mechanism for mass exclusion by adding another action to select excluded. The first action selects the items you want to exclude, the second inverses the selection so your list is now excluded.


talk is cheap, supply exceeds demand
4 Replies
MVP & Luminary
MVP & Luminary

Re: Mass selection in list box and dynamically filled exclusion list

Attached is an example (created by rebeccad) that allows you to paste a list of items in a text box to use as selection. You should be able to use the same mechanism for mass exclusion by adding another action to select excluded. The first action selects the items you want to exclude, the second inverses the selection so your list is now excluded.


talk is cheap, supply exceeds demand
Not applicable

Re: Mass selection in list box and dynamically filled exclusion list

Dear Mr Wassenaar,

thanks a lot, your example is showing exactly the required functionality. Just for my understanding: you are using an input box with predefined values Include;Exclude;No Preference;

These values somehow steer the inclusion or exclusion of the value in the other input box.

Which part in the script is responsible for the functionality? Does the statement include, exclude lead to the selection/deselection of the cariable values already or is there a part in the script that is responsible for this effect?

Thanks for the efforts spent already.

Not applicable

Re: Mass selection in list box and dynamically filled exclusion list

great solution ! and so simple

combined to a list of available selection fields can really be powerful.

just a thing, i think it might be useful to add a replace of chr(10) in case the selection list comes in rows.

thanx.

Highlighted
alan_richmond
Contributor

Re: Mass selection in list box and dynamically filled exclusion list

great solution, do you have a copy of your test.xslx that you can share