PQ
Basic Overview
Description | Shifts the input node Node one quarter into the future while retaining all other dimensions. |
Signature | PQ(Node) |
Parameters |
|
Example 1
Input Profit
Quarter | Profit |
2019-Q1 | 35 |
2019-Q2 | 42 |
2019-Q3 | 47 |
Output PQ('Profit')
Year | Profit |
2019-Q2 | 35 |
2019-Q3 | 42 |
2019-Q4 | 47 |
Example 2
SHIFT or Nested PQ expressions can be used to move Nodes further into the future.
Input Profit
Year | Profit |
2019-Q1 | 35 |
2019-Q2 | 42 |
2019-Q3 | 47 |
Output PQ(PQ('Profit'))
Year | Profit |
2019-Q3 | 35 |
2019-Q4 | 42 |
2020-Q1 | 47 |