Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

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

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!

8 Replies
Not applicable

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

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

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

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

Not applicable

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

No problem. Glad it helps!

mruehl
Contributor III

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

What a powerful tool!

Thanks a lot.

mruehl
Contributor III

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

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
Contributor

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

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

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

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
Contributor

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

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

Community Browser