Yandex DataLens

Getting started
Tutorials
Step-by-step instructions
- All instructions
- Working with connections
- Working with datasets
- Working with charts
- Working with dashboards
- Working with permissions
Concepts
Access management
Pricing policy
Function reference
- All Functions
- Aggregate functions
- Date/Time functions
- Geographical functions
  - Overview
  - GEOCODE
- Logical functions
  - Overview
  - CASE
  - IF
  - IFNULL
  - ISNULL
  - ZN
- Mathematical functions
  - Overview
  - ABS
  - ACOS
  - ASIN
  - ATAN
  - ATAN2
  - CEILING
  - COS
  - COT
  - DEGREES
  - DIV
  - EXP
  - FLOOR
  - GREATEST
  - LEAST
  - LN
  - LOG
  - LOG10
  - PI
  - POWER
  - RADIANS
  - ROUND
  - SIGN
  - SIN
  - SQRT
  - SQUARE
  - TAN
- Operators
- String functions
- Type conversion functions
- Function Availability

IFNULL

Logical functions

Syntax

IFNULL( check_value, alt_value )

Description

Returns check_value if it's not NULL. Otherwise returns alt_value.

Argument types:

check_value — Any
alt_value — Any

Return type: Same type as (check_value, alt_value)

Note

Arguments (check_value, alt_value) must be of the same type.

Examples

IFNULL([Profit], 0)

Data source support

Materialized Dataset, ClickHouse 1.1, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.