3 Replies Latest reply: Jul 4, 2017 9:04 AM by Neale Forth RSS

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

    Neale Forth

      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 !