topic if() match () with several expressions in script? in QlikView

if() match () with several expressions in script?

Wed, 25 Jun 2014 12:17:35 GMT

Hi guys,

is it possible to select several expressions like that ?

search is select all the X:

X >=400000

X <=599999

X = 677000

X = 688000

X IS NOT = 494500 494700 494800

if tried with

If(WildMatch("X",'4?????','59????','677000','688000'),'TEST') as TEST

But I don't know, how to NOT SELECT expresions ?

Kind regards.

alexandros17 — Wed, 25 Jun 2014 12:21:01 GMT

I think it is not possible with only one wildmatch ... you must use at least two, one to include and one to exclude.

Pay attention to the sysntax, first use the whole string , then the other to compare so:

If(WildMatch(TEST, "X",'4?????','59????','677000','688000')) as TEST

tresB — Wed, 25 Jun 2014 12:22:40 GMT

Try like:

If(WildMatch("X",'4?????','59????','677000','688000') and Not Match("X",'494500' ,'494700', '494800') ,'TEST') as TEST

Gysbert_Wassenaar — Wed, 25 Jun 2014 12:23:15 GMT

if( ((X >= 400000 AND X <= 599999) OR match(X, '677000', '688000')) AND NOT match(X, '494500', '494700', '494800'), 'TEST') as TEST