topic Select in Filed Expression in QlikView

Select in Filed Expression

Tue, 17 May 2011 19:06:01 GMT

I am using Select in Fileld Action and

I need some help with expression to select all the fields in the list box except two of them. For instance I need to select all fields except "ABC" or "SDF"

Select in Filed Expression

erichshiino — Tue, 17 May 2011 19:17:29 GMT

Hi,

Do it using two steps

1- Select ABC and SDF using the action Select in Field (the search string will be (ABC|SDF)

2 - Use the action selected excluded on the same field.

Regards,

Erich

Select in Filed Expression

Tue, 17 May 2011 19:33:53 GMT

Great, Still I need to exclude two strings:

Products & Services and

Sales, Market & Relationships

What is the correct syntax? I tired: Products & Services \ Sales, Market & Relationships

with quotes and without quotes, nothing is working

Select in Filed Expression

erichshiino — Tue, 17 May 2011 19:38:46 GMT

Try:

("Sales, Marketing & Relationship"|"Product & Sales")

You have to force the double quotes because there are commas, space, special character, etc

Regards,

Erich

Select in Filed Expression

Tue, 17 May 2011 19:45:03 GMT

Does not work. Actually if i use only one of these fields I have to type them as is (no any quotes) to make it work. If I put

"Sales, Marketing & Relationship" it does not work.

Sales, Marketing & Relationship without anything works.

So now I need to exclude both of them and could not find the way.

Re: Select in Filed Expression

erichshiino — Tue, 17 May 2011 19:54:16 GMT

I don't know what happened in your case.

You can check the app I used to try it on the attachment.

Re: Select in Filed Expression

Tue, 17 May 2011 20:04:51 GMT

ok, It works on V10, not in 9 that I am using. Your sample did not work on 9. Any other idea how to solve it?

Re: Select in Filed Expression

erichshiino — Tue, 17 May 2011 20:14:22 GMT

Ok,

Try if with 3 steps:

1 - Select in Field

Search string: * (this should select everything - works on qv10)

2 - Use toggle select

Search String: Sales, Marketing & Relationship

3 - Use toggle select

Search String: Product & Sales

Re: Select in Filed Expression

Tue, 17 May 2011 20:19:39 GMT

Thanks a lot. Works fine