topic How to select string values from a field using button? in QlikView

How to select string values from a field using button?

AH — Wed, 19 Nov 2014 15:05:14 GMT

Hi,

I have a column in a table which is full of strings. what i want to do is, use a part of string(substring) and use that in the search string box and want to select all the values which has that particular substring. Could anyone help me with this? Btw, I was able to achieve that with putting multiple values in searchstring box i.e, like (A|B|C|D). But I want to use substring not the whole.

I want to take the spare part substring and want to select all the rows which has that particular substring.

Thanks!

Shan

Re: How to select string values from a field using button?

npatel1 — Sat, 25 May 2024 12:24:48 GMT

Did you get a fix? I have similar query.

Re: How to select string values from a field using button?

BrunPierre — Sat, 25 May 2024 17:52:13 GMT

In response to @AH inquiry, simply use the below for a search string value.

*spare part*

Re: How to select string values from a field using button?

marcus_sommer — Wed, 29 May 2024 11:05:31 GMT

With advanced searches you will be able to select the wanted values but it's not very comfortable for standard-selections. Better will be to apply an appropriate categorizing within the script, for example something like:

pick(wildmatch(upper(Field), '*SPARE PART*', '.....'), 'Spare Stuff', '....') as Category