Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
slondono
Partner - Creator II
Partner - Creator II

Pie Chart Label

Hi everyone. I have a question for all

Does know someone a way to put a label in the squares-leyend in a pie chart?

Captura.PNG

When i put the mouse over the border of the chart, it shows me the name of the seller. I need that when i put the mouse over the square, it shows me the same thing.

Any idea? maybe someone knows a way or an extesion that can do that.

Thanks to everyone.

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

It's a bit of a hack, but the attached sample shows replacing the legend with a colored straight table. What you lose is the pie pop-out when you hover over the "legend square", but you do get the Empleado.NombreDependencia value.

I sorted both charts by rank(Sum(#Valor)) to make it easier to map the colors. It think it is possible to sort alpha as in your original example, but that does create some extra work in picking the color. Plus I think sorting by rank() makes a clearer "Top 10" chart.

2016-05-23_17-53-47.png

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

View solution in original post

10 Replies
marcus_sommer

If you pressed ctrl+shift by activated chart you get red lines around the various chart-parts within the charts which you could drag and size with the mouse.

- Marcus

slondono
Partner - Creator II
Partner - Creator II
Author

Thanks Marcus, i know that. But the names are too long, so i just need the percentage but when i put the mouse over the square then it shows me the name in a tool tip leyend. Am i clear?

marcus_sommer

Try it with a calculated dimension like:

=dual(aggr(YourExpression, YourDimension), YourDimension)

- Marcus

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

I think you can use the power of Dual function to resolve this. Something like this

Dual(FieldToDisplay & ' (' & Num(Sum(FieldNameToSum)/Sum(Total FieldNameToSum),'$(vPercenFormat)') & ')', Sum(FieldNameToSum)).

Please attach sample data or .qvw file for exactness of fields and expression calculation.

Hope this helps

slondono
Partner - Creator II
Partner - Creator II
Author

Its not working. I need the tooltip when the mouse is over the square. I have already attach a qvw

Anonymous
Not applicable

Hi, Sebastian,

I attached a file. That's what you need? I unchecked "Pop-up labels" in Presentation tab and checked "Text as Pop-up" in Expression Tab.

Regards.

slondono
Partner - Creator II
Partner - Creator II
Author

Hi Romina.

No i dont need that. What i need is that when i put the cursor over the SQUARE leyend appeas a tooltip with the NombreDependencia.

Thank u for trying

Not applicable

Hola Sebastian,

I think the pop up you are looking it is not posible.

Try to contact your final user and recomend to use the over on the chart itself.

Hope you find the way.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

It's a bit of a hack, but the attached sample shows replacing the legend with a colored straight table. What you lose is the pie pop-out when you hover over the "legend square", but you do get the Empleado.NombreDependencia value.

I sorted both charts by rank(Sum(#Valor)) to make it easier to map the colors. It think it is possible to sort alpha as in your original example, but that does create some extra work in picking the color. Plus I think sorting by rank() makes a clearer "Top 10" chart.

2016-05-23_17-53-47.png

-Rob

http://masterssummit.com

http://qlikviewcookbook.com