I have a chart with an expression of SUM(x) / SUM(y) that gives me results as percentages.
If I turn on "Full Accumulation", it sums the percentages.
What I would like is for each SUM() in my expression to sum the values from the preceding data points.
Example Data:
| Series Dimension | Time Dimension | Another Dimension | X | Y |
|---|
| A | 1 | a | 1 | 2 |
| A | 1 | b | 1 | 4 |
| A | 2 | a | 2 | 3 |
| A | 2 | b | 3 | 3 |
| A | 3 | a | 3 | 4 |
| A | 3 | b | 2 | 3 |
| B | 1 | a | 2 | 3 |
| B | 1 | b | 1 | 2 |
| B | 2 | a | 3 | 4 |
| B | 2 | b | 1 | 1 |
| B | 3 | a | 3 | 4 |
| B | 3 | b | 2 | 2 |
Which gives the following results:
| Series Dimension | Time Dimension | Percentage
| Cumulative |
|---|
| A | 1 | (1 + 1) / (1 + 4) | (1 + 1) / (1 + 4) |
| A | 2 | (2 + 3) / (3 + 3) | (1 + 1 + 2 + 3) / (1 + 4 + 3 + 3) |
| A | 3 | (3 + 2) / (4 + 3) | (1 + 1 + 2 + 3 + 3 + 2) / (1 + 4 + 3 + 3 + 4 + 3) |
| B | 1 | (2 + 1) / (3 + 2) | (2 + 1) / (3 + 2) |
| B | 2 | (3 + 1) / (4 + 1) | (2 + 1 + 3 + 1) / (3 + 2 + 4 + 1) |
| B | 3 | (3 + 2) / (4 + 2) | (2 + 1 + 3 + 1 + 3 + 2) / (3 + 2 + 4 + 1 + 4 + 2) |
Is there a standard way to accomplish this in QlikView without doubling the number of fields in the data? (field1 AND cumulativeField1, etc, etc)
Cheers,
Mat.
