PQ

In Compare periods

The PQ function shifts the input node one quarter into the future while retaining all other dimensions.

Use this function when you need last quarter’s values alongside current data for quarter-over-quarter comparisons.

Parameters

NodeNode referenceRequired

Input node that is shifted, specified using the node name in single quotes (e.g. 'Profit')

Examples

Shifting values by one quarter

Each value appears one quarter later in the result.

Input node: 'Profit'

Formula: PQ('Profit')

Shifting values by two quarters (nested PQ)

Nesting PQ calls shifts values further into the future. Here, each value moves two quarters forward. Try SHIFT as an alternative with a custom offset.

Input node: 'Profit'

Formula: PQ(PQ('Profit'))

See also

PY

When you need the previous year instead of the previous quarter.

SHIFT

When you need a custom offset or want to shift along a specific time level.

QOQ_ABS

When you need the absolute difference to the previous quarter, not just the shifted values.