topic Using "like" function in SetExpression in QlikView

Using "like" function in SetExpression

Wed, 04 Jul 2012 13:58:02 GMT

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

What's the exact sintax for this?

Thanks a lot.

Nutis

swuehl — Wed, 04 Jul 2012 14:03:21 GMT

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)

Wed, 04 Jul 2012 14:16:13 GMT

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

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