English QlikView 12.10

Logical functions

This section describes functions handling logical operations. All functions can be used in both the load script and in chart expressions.

Both IsNum and IsText return 0 if the expression is NULL.

Example:  

The following example loads an inline table with mixed text and numerical values, and adds two fields to check if the value is a numerical value, respectively a text value.

Load *, IsNum(Value), IsText(Value) Inline [ Value 23 Green Blue 12 33Red];
 

The resulting table looks like this:

Value IsNum(Value) IsText(Value)
23 -1 0
Green 0 -1
Blue 0 -1
12 -1 0
33Red 0 -1