Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Skip zero values in Pie Chart

I have the following data

ProductTeamSales
AppleJason1
LemonJason0
LemonPeter2
LemonMark3

I created a Pie chart and with Dimension = Team, Measure = Sum(Sales)

and an Filter Pane with Dimension = Product

When I select Lemon, the chart show Peter (40%) and Mark (60%) but also have a note "The data set contains negative or zero values that cannot be shown in this chart." because the value of Jason is 0.

How can I suppress the "contains zero" note?  I try use some set express in Dimension but no luck.  Thanks

1 Solution

Accepted Solutions
Highlighted
Not applicable

In the Properties pane for the Pie Chart, under the "Team" dimension - set the Limitation = Exact Value and use >0

Then untick "Show others"

View solution in original post

6 Replies
Highlighted
Not applicable

Hi ,

You cannot suppress that statement.

Instead you have to modify your data select statement as >0

Highlighted

May be use this as your expression:

If(Sum(Sales) > 0, Sum(Sales))

Highlighted
Not applicable

Sunny's expression should solve it for you

Highlighted
Not applicable

In the Properties pane for the Pie Chart, under the "Team" dimension - set the Limitation = Exact Value and use >0

Then untick "Show others"

View solution in original post

Highlighted
Not applicable

This works.  Thanks

Highlighted
Contributor II
Contributor II

Thanks for Help All.

Really Appreciated