topic Select in field values like * in QlikView

Select in field values like *

lfalmoguera — Thu, 17 Mar 2011 16:20:44 GMT

Hi all,

I´ve looking in other post the way to do this, but has not find anything yet.

Is there any way to perform the Action --> Select in Field

And within the string box select all values which are "like "String*".

I have so many Strings and want to avoid to populate all them using the (String1|String2|...|StringN).

Furthermore, the names of the Strings may change, so I need to avoid populating all of them!

Thanks a lot in advance!

Miguel_Angel_Baeyens — Thu, 17 Mar 2011 16:30:48 GMT

Hello,

You can use wildcards in the value of the field, so

String*

Will select in the field all values starting with "String".

Is that what you are looking for?

lfalmoguera — Thu, 17 Mar 2011 16:36:41 GMT

Thanks!

But the problem is that I have "empty spaces" within the strings.

For instance, imagine I have:

Calle Alcala

Avenida Alcala

Calle Gran Via

What do I write in the box to select those two with "Alcala" string?

Anonymous — Thu, 17 Mar 2011 16:40:24 GMT

Empty spaces don't matter.
What matters is that in your example you need * in the beginning as well:
*String*

lfalmoguera — Thu, 17 Mar 2011 16:43:52 GMT

I DO need to take a rest : P

Miguel_Angel_Baeyens — Thu, 17 Mar 2011 16:44:02 GMT

Hi,

Using wildcars in both left and right will return empty spaces, starting with, ending with...

*Alcala*

Hope that helps.

lfalmoguera — Thu, 17 Mar 2011 16:47:28 GMT

Thanks a lot!

What about a not like?

Miguel_Angel_Baeyens — Thu, 17 Mar 2011 16:56:14 GMT

Use two actions:

1.- Select in field *Alcala*

2.- Then Select Excluded using that field

Hope that helps

lfalmoguera — Thu, 17 Mar 2011 17:02:15 GMT

Fantastic!