Hi all,
Am new to Qlikview and am stuck in a scenario where I have to migrate a reporting application in OBI to Qlikview. A sample table looks like below.
I needed help on creating such a table. I have taken the option of Pvot table to depict this.
Columns B,C,D,E, are fetched from database, while the column A has to be added synthetically .
Please help on achieving this.
| Actual Results | Trend | Actual | YTD |
X | PY-Q1 | PY-Q2 | PY-Q3 | PY-Q4 | CY-Q1 | CY-Q2 | CY-Q3 | CY-Q4 | Q1-CY/PY | Q2-CY/PY | Q3-CY/PY | Q4-CY/PY | CY/PY | 12 Month | 12 Month | 12 Month | YTD PY | YTD CY | YTD Change | YTD Trend |
actual | actual | actual |
ending | ending | change |
PY | CY |
|
A | $1,692 |
|
|
|
|
|
|
| -7.60% | -6.40% | 1.30% | 1.60% | -3.00% |
|
|
| $1,619 |
|
|
|
B | $2,477 |
|
|
|
|
|
|
| -7.60% | -5.00% | 3.00% | 1.50% | -2.30% |
|
|
| $2,394 |
|
|
|
C | $908 |
|
|
|
|
|
|
| 6.90% | 1.30% | 1.70% | 7.00% | 4.10% |
|
|
| $924 |
|
|
|
D | $1,002 |
|
|
|
|
|
|
| 8.70% | 0.60% | 0.50% | -3.10% | 1.80% |
|
|
| $1,057 |
|
|
|
E | $401 |
|
|
|
|
|
|
| 1.80% | 4.20% | 6.30% | -3.30% | 2.40% |
|
|
| $392 |
|
|
|
F | $1,476 |
|
|
|
|
|
|
| 20.80% | 20.40% | 21.10% | -5.40% | 14.60% |
|
|
| $1,503 |
|
|
|