Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there,
I have a problem getting my pie chart right. Let me point out right away that the chart is built by 0 dimensions and three expressions. I suspect having one dimension with the three values 'a', 'b', 'c' and one expression could solve my problem, but I would rather not go that way, if possible.
Back to the problem, you can see how, although I am hovering over 'b' with the mouse, in the pop-up label we see 'a=...'.
This discussion looked promising, as it achieves to dynamically display the result of the expression within a custom text. However I would need to notch it a step further and also have the expressions' label be displayed.
Kindly mention which tool you are using for this....Qlikview or Qliksense
And please share all 3 expressions
Qlikview.
And the expression are simple SUM()s, then each expression has its own custom label, A, B and C
I have loaded below inline
LOAD * INLINE [
Name, Number
A, 100
B, 120
C, 150
];
After loading data used following expressions for each Name
Label: A
Sum({<Name={'A'}>}Number)
Label:B
Sum({<Name={'B'}>}Number)
Label:C
Sum({<Name={'C'}>}Number)
Here is my output:
In the OP i mention that my dataset is structured differently (and I would like to keep it this way), using an inline it would look like
LOAD * INLINE [ measure_a, measure_b, measure_c 100, 350, 300 200, 550, 200 ];
Then in the chart:
Label: A
Expr: SUM(measure_a)
etc..
No dimension is used in the chart