search field not contain specific text

[nzcncfan]

‌I could search from a table field which contains certain text using * . Is there a way to search from table which does not contain certain text?

THanks

[Mark_Little]

Hi,

I am not a 100% sure i know what you want, but a possible solution would be do your search for the Text you want to exclude and select the values. Then within the triple dots at the top select Alternative or select excluded.

Mark

[nzcncfan]

Thanks Mark for your reply, and it is very close to what I want.

Ideally, I would like to exclude any records below containing certain string. For instance, in the below screen, I could get all records containing "NT". But how could I search any records NOT containing "NT?

[juraj_misina · Accepted solution]

You can use minus sign before the search string. See

[nzcncfan]

Thanks Juraj for the great post.

Thanks Mark for your help.

It's great to get support from the Qlik community!

[DNGUYEN]

hi Juraj,

I tried to search for part that does not contain *PBF* BUT IT DID NOT WORK.  here is my expression. -*PBF*.

IT ONLY WORK IF I ENTERED AS -PBF. IT WILL ELIMINATE ITEMS THAT HAS -PBF BUT NOT WORK IF I ENTERED IN THE WILDCARD.  PLS HELP.

THANKS,

DNGUYEN