topic Re: set analysis not include in QlikView

set analysis not include

QSense — Wed, 23 Jan 2013 14:11:39 GMT

Hi ,

I have a set analysis expression

my expression is that

COUNT({$<Field1={">=$(=0) <$(=31)"},Field2={'*value1*value2*','*value2*value1'},Field2-=''>}fiedl3)

note: is another value

In expression side It says ok but when I checked it doesn not work correctly

I think the problem can be with Field2-='' (I try to exclude values )

Thanks for advance

Gysbert_Wassenaar — Wed, 23 Jan 2013 14:13:44 GMT

You need to use the curly brackets: Field2 -= {'M'}

Also, the expression editor has a bug to causes it to flag the -= as wrong. But it is correct nonetheless.

Wed, 23 Jan 2013 14:14:13 GMT

try Field2-={M}

QSense — Wed, 23 Jan 2013 14:20:52 GMT

Field 2 includes values with such as examp1, examp2

I mean some field2 values include at the front , end

Wed, 23 Jan 2013 14:28:08 GMT

i think in ur script u can create a field Field3 as :

if(left(Field,7)='',Field2) as Field3

and use this Field3 in set analysis as Field3={*}

or from the ref manual u can also use;

Field-={"*"}