Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.