Not include in set expression

[QSense]

Hello everyone,

This is my example

COUNT(if(wildmatch(UPPER(field_name),'*value1*','*value2*') AND NOT wildmatch(UPPER(field_name),'*value3*'),field_name3))

with and not wild match I try exclude value3 (I couldnt succeed)

and my second expression is

COUNT({$<field_name2={">=$(=0) <$(=31)"},field_name={'*value1*','*value2*'}>}field_name3

As result I want to combine two expression in one expression

[kumarnatarajan]

Hi,

Find the attached file

[QSense]

hi,

Could you send script file ?

I dont have personal edition

[QSense]

hi,

Could you send script file ?

I dont have personal edition

[QSense]

hi,

Could you send script file ?

I dont have personal edition

[QSense]

hi,

Could you send script file ?

I dont have personal edition

[kumarnatarajan]

Hi,

Script:

temp2:

load * inline [

field_name3, Value,field_name2

1, value1    ,5

2, Svalue2    ,40

3, Svalue2    ,29

4, Svalue3    ,35

] ;

1st:

COUNT(if(wildmatch(Upper(Value),'*value1*','*value2*'),field_name3))

2nd:

COUNT({$<field_name2={">=0 <=31"},Value={"*value1*","*value2*"}>}field_name3)

[QSense]

hi,

Could you send script file ?

I dont have personal edition

[QSense]

Thanks for reply ,

How can I make in expression not in script side?