topic Re: Search Expression (not equal to) in QlikView

Search Expression (not equal to)

Tue, 28 Apr 2015 09:12:17 GMT

Hi Dears,

I know if I want to select strings include Blue or Red, the search expression should be:

(*Blue*|*Red*)

my question is :

if I want to select strings exclude Blue or Red, what should the search expression be ?

-=(*Blue*|*Red*) is wrong.

Anybody could help?

Thanks in advance!

Re: Search Expression (not equal to)

anbu1984 — Tue, 28 Apr 2015 09:19:04 GMT

Re: List Box Search Expression to exclude values

Re: Search Expression (not equal to)

Tue, 28 Apr 2015 09:28:06 GMT

Thanks anbu.

I know that function.

But just wonder if the expression could get the result (not equal to Blue and Red) directly.

Re: Search Expression (not equal to)

jsanchezh — Tue, 28 Apr 2015 09:46:01 GMT

I'm not sure, but maybe you can try <> instead of -=

Re: Search Expression (not equal to)

dinuwanbr — Tue, 28 Apr 2015 11:56:04 GMT

Hi,

Can you upload a sample. Can't understand where you exactly want it.

Rgds,

Dinu1

Re: Search Expression (not equal to)

ToniKautto — Mon, 04 May 2015 22:29:01 GMT

I am not aware of syntax that allows excluding values during search.

You can also refer to the QlikView Reference Manual and the Search section (14.10 on p.106 in 11.20 SR10 manual). This specifies the search operators and wildcards.