# Conditional functions

The conditional functions all evaluate a condition and then return different answers depending on the condition value. The functions can be used in the load script and in chart expressions.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/conditional-functions.htm)

#### alt

The alt function returns the first of the parameters that has a valid number representation. If no such match is found, the last parameter will be returned. Any number of parameters can be used.

[**alt**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/alt.htm)(case1[ , case2 , case3 , ...] , else)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/conditional-functions.htm)

#### class

The class function assigns the first parameter to a class interval. The result is a dual value with a<=x<b as the textual value, where a and b are the upper and lower limits of the bin, and the lower bound as numeric value.

[**class**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/class.htm)(expression, interval [ , label [ , offset ]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/conditional-functions.htm)

#### if

The if function returns a value depending on whether the condition provided with the function evaluates as True or False.

[**if**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/if.htm)(condition , then , else)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/conditional-functions.htm)

#### match

The match function compares the first parameter with all the following ones and returns the number of the expression that matches. The comparison is case sensitive.

[**match**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/match.htm)( str, expr1 [ , expr2,...exprN ])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/conditional-functions.htm)

#### mixmatch

The mixmatch function compares the first parameter with all the following ones and returns the number of the expression that matches. The comparison is case insensitive and insensitive to the Japanese Hiragana and Katakana character systems.

[**mixmatch**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/mixmatch.htm)( str, expr1 [ , expr2,...exprN ])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/conditional-functions.htm)

#### pick

The pick function returns the n:th expression in the list.

[**pick**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/pick.htm)(n, expr1[ , expr2,...exprN])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/conditional-functions.htm)

#### wildmatch

The wildmatch function compares the first parameter with all the following ones and returns the number of expression that matches. It permits the use of wildcard characters ( \* and ?) in the comparison strings. The comparison is case insensitive and insensitive to the Japanese Hiragana and Katakana character systems.

[**wildmatch**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/wildmatch.htm)( str, expr1 [ , expr2,...exprN ])