Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
cristianj23a
Partner - Creator III
Partner - Creator III

Resident

Hi .

Help me identify what is wrong with the code because I get an error message that says "invalid expression".

NoConsiderado.PNG

https://www.linkedin.com/in/cristianjorge/
Do not forget to mark as "Accepted Solution" the comment that resolves the doubt.
11 Replies
cristianj23a
Partner - Creator III
Partner - Creator III
Author

Is there any way to sum but without grouping?

https://www.linkedin.com/in/cristianjorge/
Do not forget to mark as "Accepted Solution" the comment that resolves the doubt.
vishsaggi
Champion III
Champion III

You are using an aggregate function Sum() in your resident load, you need to add Group By after your where clause. Try that and check. So group by yourfieldname1, yourfieldname2 etc.