topic Re: Not include in set expression in QlikView

Not include in set expression

QSense — Wed, 23 Jan 2013 12:27:56 GMT

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

Re: Not include in set expression

kumarnatarajan — Wed, 23 Jan 2013 12:50:29 GMT

Hi,

Find the attached file

Re: Not include in set expression

QSense — Wed, 23 Jan 2013 12:54:49 GMT

hi,

Could you send script file ?

I dont have personal edition

Re: Not include in set expression

QSense — Wed, 23 Jan 2013 12:54:56 GMT

hi,

Could you send script file ?

I dont have personal edition

Re: Not include in set expression

QSense — Wed, 23 Jan 2013 12:55:01 GMT

hi,

Could you send script file ?

I dont have personal edition

Re: Not include in set expression

QSense — Wed, 23 Jan 2013 12:55:06 GMT

hi,

Could you send script file ?

I dont have personal edition

Re: Not include in set expression

kumarnatarajan — Wed, 23 Jan 2013 13:10:54 GMT

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)

Re: Not include in set expression

QSense — Wed, 23 Jan 2013 13:15:08 GMT

hi,

Could you send script file ?

I dont have personal edition

Re: Not include in set expression

QSense — Wed, 23 Jan 2013 13:17:42 GMT

Thanks for reply ,

How can I make in expression not in script side?