topic Input Box Help - Mulitple Search Items in QlikView

Input Box Help - Mulitple Search Items

pnn44794 — Sun, 13 Oct 2019 00:36:56 GMT

Hello:

I have an Input Box field and associated Search Button where users are able to input a list of Order ID's from a single Excel column (copy and paste of values) or a comma separated list and then click on Search for just those Order ID's.

The problem I have is that some Order ID's have two leading zeros, but not all Order ID's do. This is causing those Order ID's with leading zero's to not be "found". That's problem 1.

Problem 2, is I also get just a row with an Order ID with no other data after I manually strip any leading zeros.

Any idea how to, 1) Get rid of the leading zeros and allow the search and 2) Eliminate or populate the rows with just an Order ID?

Re: Input Box Help - Mulitple Search Items

marcus_sommer — Mon, 06 Nov 2017 13:28:00 GMT

It's not quite clear for me where the leading zeros are - within the search-list or within the qv field-values?

Both sides - searchvalue and fieldvalue - must have the same structure to get a match. I think this meant you need to enforce respectively adjust this structure - maybe by formatting the excel-values to a string (which meant they will keep leading zeros) or by loading the qv field purely numeric without leading zeros (maybe within an extra field and using this for the selection).

- Marcus

Re: Input Box Help - Mulitple Search Items

pnn44794 — Tue, 14 Nov 2017 22:20:14 GMT

Hello Marcus:

My apologies for the delay in replying. I've been out. Anyway, you are correct. It's a formatting problem within Excel. Fixed that and it works now. Thank you for the help.