Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is it possible to select hundreds of products by using a search string in the GUI?

Hi,

We frequently have to analyze sales figures for several hundred products (a different set of products each time). The list of products is provided in Excel and can easily be converted into a search string. However, the string is too long to be pasted into a search field or to be used in an andvanced search expression.

Changing the load script and flagging the sales records is an option which we have in mind but this is not an optimal solution.

Is there any other possibility in QV to enable users to select a large number of records via the GUI?

Kind regards,

Thomas

1 Solution

Accepted Solutions
Not applicable
Author

Here is an example that I buillt with lots of help from the Community.  Our users select a lot of Shipment ID numbers from Excel and paste them into the input box.  When you select Search, it returns the values using a select in field string. Hope it helps!

View solution in original post

8 Replies
Not applicable
Author

Here is an example that I buillt with lots of help from the Community.  Our users select a lot of Shipment ID numbers from Excel and paste them into the input box.  When you select Search, it returns the values using a select in field string. Hope it helps!

Not applicable
Author

This is amazing! Simple and yet so powerfull. Our users will love this new feature. Thank you very much!

Not applicable
Author

No problem. Glad it helps!

mruehl
Partner - Specialist
Partner - Specialist

What a powerful tool!

Thanks a lot.

mruehl
Partner - Specialist
Partner - Specialist

I have got a problem with the input selection in the AJAX-Version.

Running it in the dat client works very well

In Firefox i can paste the values from Excel to the input field, but the search-Button doesnt work.

In IE i cant paste alle values into the input field, it only accepts one itemnumber.

anyone an idea ?

rsdhavle
Creator II
Creator II

Hi Rebecca,

This is great solution for hiding and selecting column as well however suppose we want to show 4-5 columns in table chart independent of the selection from 'Build YOur Report Box' what changes needs to be done?

I think because of GetSelectedCount(Fields)>0  condition not a single column is visible in a table chart


Not applicable
Author

Rohan - I don't think I am clear on what you are trying to do.  If you can send me a sample file with what you are looking for I can help.

rsdhavle
Creator II
Creator II

Rebecca,

Thanks it worked for me now.

I was trying to make few columns from the table independent of the condition GetSelectedCount(Fields)>0  so that those columns would not be dependent on this condition