Error in pie chart

[Iresha_Imali]

why am I getting an error in pie chart. Please help me to remove this.

[vighnesh_gawad · Accepted solution]

Convert that pie chart into table and check if they are any negative or zero values. You cant have pie chart where some values are in negative. Either convert those values into positive or use different chart to show both negative and positive values.

[Chanty4u]

Hi

Try this in your measure 

Sum({<Value={">0"}>} Value)

Or post your sample data and dim and measures used 

[priscilarubim]

From what I know, pie charts in Qlik Sense don't support negative or zero values, as they work with proportional slices, so any value ≤ 0 will trigger that error.

One approach that might work is wrapping your measure with an If() condition to filter those out:

If(SUM(YourField) > 0, SUM(YourField))
or
Sum({<YourField = {">0"}>} YourField)

But this assumes that the negative values are not relevant to your analysis.

Hope it helps! 🙂