Skip to main content

Logical functions

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

Information noteBoth IsNum and IsText return 0 if the expression is NULL.


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:

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

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!