Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
imark
New Contributor II

Expression label as pop up text in pie chart

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=...'.

 


MyPyChart.png

 

 

 

 

 

 

 

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.

Labels (2)
4 Replies
pritamb89
Contributor

Re: Expression label as pop up text in pie chart

Kindly mention which tool you are using for this....Qlikview or Qliksense

And please share all 3 expressions

imark
New Contributor II

Re: Expression label as pop up text in pie chart

Qlikview.

And the expression are simple SUM()s, then each expression has its own custom label, A, B and C

pritamb89
Contributor

Re: Expression label as pop up text in pie chart

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)

Properties.PNG

Here is my output:

Pie.PNG

imark
New Contributor II

Re: Expression label as pop up text in pie chart

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