topic Anyone see the issue here... in QlikView https://community.qlik.com/t5/QlikView/Anyone-see-the-issue-here/m-p/1005635#M341633 <HTML><HEAD></HEAD><BODY><P>I have the following script and I can't for the life of me figure out why the sum isn't working, can anyone see anything that I'm missing?</P><P></P><P><IMG alt="QVScript.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105683_QVScript.JPG" style="width: 620px; height: 177px;" /></P><P>It seems to fail with an invalid expression on the sum but I really don't know why!!</P></BODY></HTML> Mon, 16 Nov 2015 17:38:55 GMT 2015-11-16T17:38:55Z Anyone see the issue here... https://community.qlik.com/t5/QlikView/Anyone-see-the-issue-here/m-p/1005635#M341633 <HTML><HEAD></HEAD><BODY><P>I have the following script and I can't for the life of me figure out why the sum isn't working, can anyone see anything that I'm missing?</P><P></P><P><IMG alt="QVScript.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105683_QVScript.JPG" style="width: 620px; height: 177px;" /></P><P>It seems to fail with an invalid expression on the sum but I really don't know why!!</P></BODY></HTML> Mon, 16 Nov 2015 17:38:55 GMT https://community.qlik.com/t5/QlikView/Anyone-see-the-issue-here/m-p/1005635#M341633 2015-11-16T17:38:55Z Re: Anyone see the issue here... https://community.qlik.com/t5/QlikView/Anyone-see-the-issue-here/m-p/1005636#M341634 <HTML><HEAD></HEAD><BODY><P>You need to either add the other fields not getting aggregated in your Group By Statement or you need to remove them from this resident load.</P><P></P><P>All the fields which are not aggregated need to show up in Group By Statement.</P></BODY></HTML> Mon, 16 Nov 2015 17:40:50 GMT https://community.qlik.com/t5/QlikView/Anyone-see-the-issue-here/m-p/1005636#M341634 sunny_talwar 2015-11-16T17:40:50Z Re: Anyone see the issue here... https://community.qlik.com/t5/QlikView/Anyone-see-the-issue-here/m-p/1005637#M341635 <HTML><HEAD></HEAD><BODY><P>Yes I can see the issue.</P><P></P><P>Your LOAD statement lists a lot of fields (2nd, 3rd and 4th) without aggregation functions that are not specified in the GROUP BY clause. This is forbidden. Either specify them inside an aggregation function call, or list them in the GROUP BY clause.</P><P></P><P>Best,</P><P></P><P>Peter</P></BODY></HTML> Mon, 16 Nov 2015 17:42:13 GMT https://community.qlik.com/t5/QlikView/Anyone-see-the-issue-here/m-p/1005637#M341635 Peter_Cammaert 2015-11-16T17:42:13Z