Negative Search

[NareshGuntur]

Hi,

I am trying to do a negative search.

In a normal list box, I have values like Japan, Singapore, UK & USA. If I search for Japan, Japan will be shown. I wanted to select everything except Japan. so is there any negative search that I can use??

I have tried some symbols but failed.

I know that I can search for Japan, select it and then "Select Excluded".

But I wanted that in one step.

Cheers,

Naresh

hic‌jagan‌gwassenaar‌stalwar1‌

[swuehl]

You're welcome.

Do you really need the last star symbol? Do you need to exclude values like 'Japan' and 'Japanese'?

[swuehl]

2) Misunderstood your comment. Thought you have seen this working

I agree that these kind of searches should be easier, I was hoping you had access to a new beta version...

[NareshGuntur]

You are correct again

* at the end is not required.

Modified my response.

Cheers,

Naresh

[sunny_talwar]

I wish I did .

For search (actually for any QlikView question that I have or might have), you are my go to man.

[santiago_respane]

Swuehl this is excelent!

Using your solution i solved it doing as follows:

-Lets suppose i want to exclude values when i select on field X

-i created a copy of the field named excludedX

-Added a field trigger for excludedX that when i select a value in it, it selects the field X using your wildcard like this:

    ='(*^' & ONLY(excludedX) & ')'

do you think this is a good solution?

Kind regards,

[kamal_sanguri]

There is one more cool way to do that.. Just search and select the value you want to exclude and add a trigger to select excluded values..

Attaching a QVW to review..

-Kamal

[NareshGuntur]

Just noticed

-Japan(hyphen Japan) is also working the same way.

Cheers,

Naresh