Qlik Sense Chart.The data set contains negative or zero values.

[Anonymous]

Hi Everyone,

I have a simple pie chart that keeps telling me the following error message when displayed: The data set contains negative or zero values that cannot be shown in this chart:

The expression I am using is Count({$<[Project Type]={"Pre-Construction"}>}[CRM Number])

I have checked that "CRM Number" field is populated and not negative. Same with "Project Type" ?

Not sure what else to check ? Can anyone shed any light where I am going wrong ?

Thanks !

Neale

[aaronnayan]

Try this

=fabs(Count({$<[Project Type]={"Pre-Construction"}>}[CRM Number]))

[felipedl]

Hi Neale,

For the dimension on the pie chart your using, it could be that your expression is leading to zero values.

Try converting the chart to a simple table to check the values your getting.

Felipe.

[Anonymous]

Have tried that and still get same error

But thanks Thanks Aaron.

[juleshartley]

I'm having the same problem

[Deepak87]

 Hi @juleshartley 

Try the below option in the pie chart.

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

Regards,

Deepak

[Ciara]

I wasn't the OP so I can't mark your answer as the solution but it solved this exact query for me.  Thanks so much Deepak. 👍