Discussion board where members can get started with Qlik Sense.
I have the following data
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
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
You cannot suppress that statement.
Instead you have to modify your data select statement as >0
May be use this as your expression:
If(Sum(Sales) > 0, Sum(Sales))
Sunny's expression should solve it for you
This works. Thanks
Thanks for Help All.