set analysis not include

[QSense]

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]

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.

[#3]

try Field2-={M}

[QSense]

Hello Gysbert and qlik_techie,

Field 2 includes values with such as examp1, examp2

I mean  some field2 values include at the front , end

[#5]

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-={"*"}