Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
neale1970
New Contributor III

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

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

2 Replies
rittermd
Honored Contributor

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

Not sure.  But try single quotes around the value.

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

neale1970
New Contributor III

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

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

Community Browser