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

[Anonymous]

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

[rittermd]

Not sure.  But try single quotes around the value.

Also, are you sure that you have data that meets this expression value?

[Anonymous]

Hi Mark,

Do you mean like this : count({$<[Project Type]={'Pre-Construction'}>} [CRM Number])

Have tried this and still get the error mssg .

I have a KPI box using exactly the same measure and  I have 14 projects showing....I must have check the data about 10 times and I have values for each record....

Thanks for your email.

Neale