I suspect that the issue lies in how you are comparing values in your conditional.
Change this: <cfif qTrend.LRF gt 0> to this: <cfif val(qTrend.LRF) gt 0> to force the value to numeric. If it's blank (CF interprets database nulls as empty strings), then val('') is 0.
The issues is that when using the <cfchartdata> tag it will not accept a blank, null, space without creating an error. I did not find a resolve in using this method to insert my chart values so I created a work around that is working.
I removed the <cfchartdata> tag all together and built an ArrayNew(2) to pass both item and value data. Like shown here
<cfif qTrend.LRF gt 0>
THEN pass in the Array in the <cfchartseries> tag as show below:
NOTE: this attribute will only take an Array of Arrays so make sure you do not attempt to insert an Array with a Struct in it... ERROR!
There were many ways to write this but for some reason between CF11, Tomcat, and ZingCharts this is the only way I found other then completely removing the <cfchartseries> tags and completely working around CF11 and using the "style" .js file to built the entire chart.
I really hope this helps the next person looking for this FIX....!!
I am also open to other ways ... so if you like please continue to post to this if you find a better simpler way...THANKS