Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
slondono
Partner
Partner

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

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
MVP & Luminary
MVP & Luminary

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
Partner
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
MVP & Luminary
MVP & Luminary

Try it with a calculated dimension like:

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

- Marcus

Gabriel
Partner
Partner

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
Partner
Author

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

rominavilla
Contributor III
Contributor III

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
Partner
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

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