2 Replies Latest reply: Aug 17, 2017 9:35 AM by Neale Forth RSS

    Qlik Sense Cloud. Chart error mssg: Data contains negative or zero values

    Neale Forth

      Hi Qlik Community,

       

      I have this error in many charts now - I think I must have some basic miss understanding of a principle.......really hope you can help.

       

      Example I have a pie chart and want to display no. of Projects in each Sector - for Projects of type "Pre-Construction".

       

      So I have my pie chart set up with :

       

      Dimension = Sector.

       

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

       

      and it displays the error ,mssg "the data set contains negative of zero values........."

       

      If I just use  =Count([CRM Number]) as the measure, I don't get the error message.  So its something to do with when I add the condition selecting Pre-construction projects only......

       

      I have double checked that the data set does not contain zero/blank values and also the integers etc, etc.

       

      Can any one help / explain ?

       

      Many thanks,

       

      Neale