Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

neale1970
New 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

3 Replies
aaronnayan
Contributor

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

Try this

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

felipedl
Valued Contributor III

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

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
New Contributor III

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

Have tried that and still get same error

But thanks Thanks Aaron.

Community Browser