topic Issue with sum, count,etc. in QlikView https://community.qlik.com/t5/QlikView/Issue-with-sum-count-etc/m-p/1008586#M342439 <HTML><HEAD></HEAD><BODY><P>Hi, I have a rare issue that can't resolve. I have data in one table but when I tried to do a simple sum (or any other aggregation formulae) it doesn't work.</P><P></P><P>Anyone knows why is this possible?<IMG alt="issue.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108895_issue.jpg" style="height: 390px; width: 620px;" /></P><P></P><P>Best regards,</P><P>Andrés</P></BODY></HTML> Mon, 14 Dec 2015 08:24:45 GMT andrespa 2015-12-14T08:24:45Z Issue with sum, count,etc. https://community.qlik.com/t5/QlikView/Issue-with-sum-count-etc/m-p/1008586#M342439 <HTML><HEAD></HEAD><BODY><P>Hi, I have a rare issue that can't resolve. I have data in one table but when I tried to do a simple sum (or any other aggregation formulae) it doesn't work.</P><P></P><P>Anyone knows why is this possible?<IMG alt="issue.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108895_issue.jpg" style="height: 390px; width: 620px;" /></P><P></P><P>Best regards,</P><P>Andrés</P></BODY></HTML> Mon, 14 Dec 2015 08:24:45 GMT https://community.qlik.com/t5/QlikView/Issue-with-sum-count-etc/m-p/1008586#M342439 andrespa 2015-12-14T08:24:45Z Re: Issue with sum, count,etc. https://community.qlik.com/t5/QlikView/Issue-with-sum-count-etc/m-p/1008587#M342440 <HTML><HEAD></HEAD><BODY><P>Done, it was an issue with the data model. A circular reference between two fields.</P></BODY></HTML> Mon, 14 Dec 2015 08:27:31 GMT https://community.qlik.com/t5/QlikView/Issue-with-sum-count-etc/m-p/1008587#M342440 andrespa 2015-12-14T08:27:31Z Re: Issue with sum, count,etc. https://community.qlik.com/t5/QlikView/Issue-with-sum-count-etc/m-p/1008588#M342441 <HTML><HEAD></HEAD><BODY><P>may be Format of Amount Field is not a number...</P><P></P><P>Can you try like:</P><P></P><P>=sum(num(Amount))</P></BODY></HTML> Mon, 14 Dec 2015 08:34:33 GMT https://community.qlik.com/t5/QlikView/Issue-with-sum-count-etc/m-p/1008588#M342441 Anonymous 2015-12-14T08:34:33Z