Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Not applicable

Re: Skip zero values in Pie Chart

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

Then untick "Show others"

5 Replies
Not applicable

Re: Skip zero values in Pie Chart

Hi ,

You cannot suppress that statement.

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

MVP
MVP

Re: Skip zero values in Pie Chart

May be use this as your expression:

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

Not applicable

Re: Skip zero values in Pie Chart

Sunny's expression should solve it for you

Not applicable

Re: Skip zero values in Pie Chart

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

Then untick "Show others"

Not applicable

Re: Skip zero values in Pie Chart

This works.  Thanks