Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Anyone see the issue here...

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?

QVScript.JPG

It seems to fail with an invalid expression on the sum but I really don't know why!!

1 Solution

Accepted Solutions
sunny_talwar

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.

All the fields which are not aggregated need to show up in Group By Statement.

View solution in original post

2 Replies
sunny_talwar

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.

All the fields which are not aggregated need to show up in Group By Statement.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Yes I can see the issue.

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.

Best,

Peter