topic Mass selection in list box and dynamically filled exclusion list in QlikView

Mass selection in list box and dynamically filled exclusion list

Tue, 04 Dec 2012 16:02:29 GMT

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

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

Gysbert_Wassenaar — Tue, 04 Dec 2012 20:15:04 GMT

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.

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

Wed, 05 Dec 2012 09:03:13 GMT

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.

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

Fri, 13 Nov 2015 15:52:30 GMT

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.

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

alan_richmond — Wed, 27 Feb 2019 22:05:51 GMT

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