Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not sure. But try single quotes around the value.
Also, are you sure that you have data that meets this expression value?
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