Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have a set analysis expression
my expression is that
COUNT({$<Field1={">=$(=0) <$(=31)"},Field2={'*value1*value2*','*value2*value1'},Field2-='
note:
In expression side It says ok but when I checked it doesn not work correctly
I think the problem can be with Field2-='
Thanks for advance
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.
try Field2-={M}
Hello Gysbert and qlik_techie,
Field 2 includes values with
I mean some field2 values include
i think in ur script u can create a field Field3 as :
if(left(Field,7)='
and use this Field3 in set analysis as Field3={*}
or from the ref manual u can also use;
Field-={"*