Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pie chart not showing properly

I followed the instructions to create a slice called "others" as per the instructions in my book. But, I don't see "others" next to the percentage for "others" group.

Capture.JPG.jpg

Instructions -

1. Right-click on the pie chart and select Properties….

2. Go to the Expressions tab, and select Add to add a new expression.

3. Enter the following expression:

if(count(distinct [Carrier Name]) = 1, [Carrier Name], 'Others')

4. For the Label field of the expression, enter  Carrier and enable the Values on

Data Points option.

10 Replies
Not applicable
Author

Can u attach ur sample QVW file?

arulsettu
Master III
Master III

hi

in properties dimensions limits tab enable show others...

hope it helps

MK_QSL
MVP
MVP

Follow below steps....

Create a Pie Chart


Dimension

[Carrier Name]

Dimension Limit

Tick Restrict Which Values are Displayed Using the First Expression

Show Only Values that Accumulate to

50%  Relative to the Total Use Largest Value

Tick Include Boundary Values

Tick Show Others

Expression (Two Expressions)

SUM([# Transported Passengers])

Tick Values on Data Points

IF(Count(DISTINCT [Carrier Name])=1, [Carrier Name],'Others')

Tick Values on Data Points

Not applicable
Author

HI ,

I guess it won't show you the label ,As Values on Data Points only give the values and lemme now if labels with values are possible.

Thanks

Saurabh

MK_QSL
MVP
MVP

Try it and let me know !!

Not applicable
Author

Dear Manish,

I tried but it wasn't showing the labels.. its showing only values..

Could you Pls share the sample Qvw in which i can see the both .

Thanks ..

MK_QSL
MVP
MVP

Check enclosed file..

Not applicable
Author

Thanks alot Manish

Not applicable
Author

In presentation tab, I had unchecked show legend because I only wanted to see the pie. I still don't know why there is no 'others' next to that 49%. I am attaching my qvw file. Please help me to make it work.

Thanks.