Skip to main content

String operators

There are two string operators. One uses the string values of the operands and return a string as result. The other one compares the operands and returns a boolean value to indicate match.

String operators
String operator Operator description
&

String concatenation. The operation returns a text string, that consists of the two operand strings, one after another.

Example:  

'abc' & 'xyz' returns 'abcxyz'
like

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).

Example:  

'abc' like 'a*' returns True (-1)

'abcd' like 'a?c*' returns True (-1)

'abc' like 'a??bc' returns False (0)

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com