Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create a pivot hypercube with two dimensions in a mashup, but I can't get it to use the second dimension, it just sums by the first one.
I created the hypercube using the Hypercube builder.
Am I doing something wrong or is this a limitation of Qlik Sense?
Input data -
Option | Duration | Value |
---|---|---|
A | 1 | 0.1 |
A | 2 | 1.5 |
A | 3 | 2 |
B | 2 | 1.25 |
B | 3 | 2.1 |
C | 2 | 1.6 |
What I want -
Option | 1 | 2 | 3 |
---|---|---|---|
A | 0.1 | 1.5 | 2 |
B | 1.25 | 2.1 | |
C | 1.6 |
What I get -
Option | Sum(Value) |
---|---|
A | 3.6 |
B | 3.35 |
C | 1.6 |
I needed to add "qNoOfLeftDims": 1
I needed to add "qNoOfLeftDims": 1