Skip to main content

Logical functions

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

Information noteBoth 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:

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

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