QOQ_ABS

In Compare periods

The QOQ_ABS function returns the absolute growth for each quarter compared to the previous quarter (quarter-over-quarter).

Use this function when you need the absolute difference between consecutive quarters.

Parameters

NodeNode referenceRequired

Input node, specified in single quotes (e.g. 'Profit')

MissingValueBehaviourKeywordOptional

How missing values are treated. Default: "IGNORE_MISSING".

• "IGNORE_MISSING": Missing rows are skipped. This is the default.
• "MISSING_AS_ZERO": Missing rows are treated as 0.

Examples

Default: ignoring missing values

This example shows QOQ_ABS with the default behavior. The missing quarter 2026-Q1 is skipped and 2026-Q2 is not calculated.

Input node: 'Profit'

Formula: QOQ_ABS('Profit')

Equivalent to: QOQ_ABS('Profit', "IGNORE_MISSING")

Treating missing values as zero

With MISSING_AS_ZERO, gaps are filled with 0, producing results for every quarter including those without input data.

Formula: QOQ_ABS('Profit', "MISSING_AS_ZERO")

See also

QOQ_REL

When you need the percentage change quarter-over-quarter instead of the absolute difference.

YOY_ABS

When you need the absolute difference on a yearly basis instead of quarterly.

DELTA_ABS

When you need the absolute change along any dimension, not just time.