topic Searching Stripped Values in QlikView

Searching Stripped Values

Wed, 24 Nov 2010 19:22:30 GMT

Hi Community,

Does anyone know if it is possible to do searches on listboxes or in a search box for the stripped down version of a result?

What I mean by this, for example I have product codes 1-1/2ABC, I would like to just search 112ABC to find the result.....

Thanks,

Searching Stripped Values

Wed, 24 Nov 2010 20:37:20 GMT

Create a listbox with an expression in it instead of the field. Start by creating a new listbox and in the list of fields look for the <expression> entry and click on that. For an expression use something like this: (assuming that your field name is PRODUCT)

=replace(replace(PRODUCT,'/',''),'-','')

That expression will remove slash and dash characters. You can make selections on the values and the selections will actually be made on the PRODUCT field.

Searching Stripped Values

Wed, 24 Nov 2010 21:02:05 GMT

Tim,

Thanks for the response, it is technically what I wanted to accomplish however it really slows down the search. I guess I can load this into the script somehow....

Searching Stripped Values

Anonymous — Thu, 25 Nov 2010 03:04:31 GMT

Hey Les,

You can create a searchfield in the script. I'd suggest using PurgeChar() to remove the characters you don't want.

Load
Field,
PurgeChar(Field,'-/#') as SearchField;
LOAD * INLINE [
Field
1-1/2ABC
];