Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Pie chart names

Hi,

I need to put names on my pie chart.

For example I have revenue category named contracts with 55%. So I need on my pie name on a slice: Contracts 55%.

No legend.

I tried to do the following:

created expression which does:

if (count (distinct [Revenue Category])=1,[Revenue Category], 'Others') with Data value on points.

But it did not help.

Please advise.

Thanks,

1 Solution

Accepted Solutions
Employee
Employee

Re: Pie chart names

There is a very good example in the Developer Cookbook.

I am attaching the exercise file for you to see the expression.

You can modify it accordingly and use it on your pie label.

I hope this helps :-)

Agis

8 Replies
Employee
Employee

Re: Pie chart names

There is a very good example in the Developer Cookbook.

I am attaching the exercise file for you to see the expression.

You can modify it accordingly and use it on your pie label.

I hope this helps :-)

Agis

MVP
MVP

Re: Pie chart names

PFA

Employee
Employee

Re: Pie chart names

Hello Inna

Could you please let us know if the answers helped or is it something else you are looking for?

Regards

Agis

Not applicable

Re: Pie chart names

Hi,

answer of Massimo seems to be helpful, but I confess, complicated for understanding it myself.

Would like to get explanation for his model.

Thanks,

Not applicable

Re: Pie chart names

Hi Inna,

You can add text(s) in the presentation Tab of the Chart Properties(Text in Chart). The text can be Static Text or Expression.

Regs

Ram

Not applicable

Re: Pie chart names

Hi Massimo,

I tried it on my model with the following formula attached in notepad.

But I got a pie without a name (attached picture).

Please assist.

Not applicable

Re: Pie chart names

Hi,

I don't understand how to implement it.

I have Contracts, Spare Parts, Consumables, T&M for the chart.

How do I write expressions?

Employee
Employee

Re: Pie chart names

Agis and Massimo have both provided great solutions to your problem using the dual() function and then showing 'Values on Data Points' in the expressions tab.  For more information you might consider taking the QlikView Designer Course which will teach you how to write expressions and build charts among other things.  For more information see the course description below:

http://www.qlik.com/us/services/training/recommended-courses/courses/designer-version-11

Community Browser