Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Sorry, this thread is almost 4 years old and your expression is missing context (like how the fields are related in your data model).
Please create a new thread and attach a sample QVW or some example data as shown above.