topic SQL ERROR in QlikView https://community.qlik.com/t5/QlikView/SQL-ERROR/m-p/427386#M489988 <HTML><HEAD></HEAD><BODY><P>Hello ,</P><P>While debugging sql code Im getting this error</P><P><IMG __jive_id="25020" class="jive-image-thumbnail jive-image" onclick="" alt="sqlerror.png" src="https://community.qlik.com/legacyfs/online/25020_sqlerror.png" width="450" /></P></BODY></HTML> Tue, 13 Nov 2012 08:25:49 GMT QSense 2012-11-13T08:25:49Z SQL ERROR https://community.qlik.com/t5/QlikView/SQL-ERROR/m-p/427386#M489988 <HTML><HEAD></HEAD><BODY><P>Hello ,</P><P>While debugging sql code Im getting this error</P><P><IMG __jive_id="25020" class="jive-image-thumbnail jive-image" onclick="" alt="sqlerror.png" src="https://community.qlik.com/legacyfs/online/25020_sqlerror.png" width="450" /></P></BODY></HTML> Tue, 13 Nov 2012 08:25:49 GMT https://community.qlik.com/t5/QlikView/SQL-ERROR/m-p/427386#M489988 QSense 2012-11-13T08:25:49Z Re: SQL ERROR https://community.qlik.com/t5/QlikView/SQL-ERROR/m-p/427387#M489989 <HTML><HEAD></HEAD><BODY><P>It looks like you might have an identifier, or maybe a portion of your script that has a Null value or Zero where a number is required, like a divisor, or something.&nbsp; It looks like you are summing something, and then dividing it by another sum.&nbsp; Maybe there is an empty field or a missing value that QV does not like.&nbsp; I would rebuild your script formulas in a chart object, like a straight table.&nbsp; put each needed field in it's own column and see if there are any zeros or Nulls where a number is expected.&nbsp; </P><P></P><P>That is where I would start.</P></BODY></HTML> Tue, 13 Nov 2012 15:01:20 GMT https://community.qlik.com/t5/QlikView/SQL-ERROR/m-p/427387#M489989 hallquist_nate 2012-11-13T15:01:20Z