Solved: Using "like" function in SetExpression - Qlik Community

Report Inappropriate Content · ‎2012-07-04

It's possible to use like function in Set Expression?

What's the exact sintax for this?

Thanks a lot.

Nutis

swuehl · ‎2012-07-04

Like is a string operator, the Help says about like operator:

	String comparison with wildcard characters. The operation returns a boolean true (-1) if the string before the operator is matched by the string after the operator. The second string may contain the wildcard characters * (any number of arbitrary characters) or ? (one arbitrary character).
	Examples: 'abc' like 'a' returns true (-1) 'abcd' like 'a?c' returns true (-1) 'abc' like 'a??bc' returns false (0)

You can use the string operator e.g. in a field modifier search expression, e.g.

=sum({<Name= {"=Name like '*Stefan*'"}>} Value)

swuehl · ‎2012-07-04

Like is a string operator, the Help says about like operator:

	String comparison with wildcard characters. The operation returns a boolean true (-1) if the string before the operator is matched by the string after the operator. The second string may contain the wildcard characters * (any number of arbitrary characters) or ? (one arbitrary character).
	Examples: 'abc' like 'a' returns true (-1) 'abcd' like 'a?c' returns true (-1) 'abc' like 'a??bc' returns false (0)

You can use the string operator e.g. in a field modifier search expression, e.g.

=sum({<Name= {"=Name like '*Stefan*'"}>} Value)

Report Inappropriate Content · ‎2012-07-04

If you want a equivalent expression of SUM(X) WHERE Y LIKE '*Pippo*', you can use SetAnalysis like this:

Sum( {<Y = {'*Pippo*'}>} X)