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 !

       

      Neale