QOQ_REL
QOQ_REL('Node' [, "MissingValueBehaviour"])
The QOQ_REL function returns the relative growth for each quarter compared to the previous quarter (quarter-over-quarter).
Use this function when you need the percentage change between consecutive quarters.
Parameters
- NodeNode referenceRequired
- Input node, specified using the node name 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_REL with the default behavior. The missing quarter 2026-Q1 is skipped and 2026-Q2 is not calculated.
Input node: 'Profit'
| Quarter | Value |
|---|---|
| 2025-Q1 | 200 |
| 2025-Q2 | 300 |
| 2025-Q3 | 450 |
| 2025-Q4 | 500 |
| 2026-Q2 | 100 |
Formula: QOQ_REL('Profit')
Equivalent to: QOQ_REL('Profit', "IGNORE_MISSING")
| Quarter | Calculation | Result |
|---|---|---|
| 2025-Q2 | (300 - 200) / 200 | 0.5 |
| 2025-Q3 | 150 / 300 | 0.5 |
| 2025-Q4 | 50 / 450 | 0.11 |
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_REL('Profit', "MISSING_AS_ZERO")
| Quarter | Calculation | Result |
|---|---|---|
| 2025-Q2 | (300 - 200) / 200 | 0.5 |
| 2025-Q3 | 150 / 300 | 0.5 |
| 2025-Q4 | 50 / 450 | 0.11 |
| 2026-Q1 | (0 - 500) / 500 | -1 |
| 2026-Q3 | (0 - 100) / 100 | 0 |
2026-Q2 is not present in the result: even with MISSING_AS_ZERO, dividing by a zero previous value causes a division by zero, so the entry is dropped.