Pie chart percentage

[#1]

Hi All, I have dynamic percentage. I want to show that % in pie chart against 100%. so if I have 40% in green then 60% must be in greay. Please help me on this.

[qlikview979]

May be it will help full for you,

write the expression in background color

Graycode:-RGB(219,219,219)

RGB value for the grey in list box | Qlik Community

Show Percents in Pie Chart | Qlik Community

[rahulpawarb]

Hello Narendra,

Pie Chart coloring is done on the basis of list of values of the selected dimension wrt added expression. In attached example, we have Pie Chart with Product Category dimension and Total Sales as an expression. Listed dimension have 3 different values - Accessories, Bikes & Clothing. Therefore, We could see three different colors on Pie Chart i.e. Green, Grey & Lime for First, Second & Third value of added dimension.

I am not sure we can add coloring to Pie Chart on the basis of percentage i.e. 60% or 40%. Might be I don't know that side of Pie Chart.

Regards!

Rahul

[Anil_Babu_Samineni]

I would suggest you to create Bucket in Back end then use That field into Front end with consideration of Colors

[#5]

Hi,

Have used formula to calculate%.

Sum(Actual)/100... It shows 55%

Now I want to show 55% out of 100%.

So 55% will be green and rest is greay. What dimensions or metric we need to define?

[Anil_Babu_Samineni]

May be do this? I assume, You are not using Relative Function

Expression - Num(sum(Actual)/100,'#,#0%')

BG Expression -- If(sum(Actual)<=55, Green(), LightGray())

[ankit777]

Hi

You should use a dimension using a valuelist function.

Use in dimemsion-=ValueList('list','Actual','Other')

IN expression= if(ValueList('list','Actual','Other') ='Actual',formulafor%,
if(ValueList('list','Actual','Other') ='2',1-formulafor%))

Another option would be using a Gauge chart instead of Pie