Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
neale1970
Contributor III
Contributor III

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

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

6 Replies
aaronnayan
Creator III
Creator III

Try this

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

felipedl
Partner
Partner

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.

neale1970
Contributor III
Contributor III
Author

Have tried that and still get same error

But thanks Thanks Aaron.

juleshartley
Specialist
Specialist

I'm having the same problem

Deepak87
Partner
Partner

 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
Creator
Creator

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. 👍