Re: Resident - Page 2 - Qlik Community

cristianj23a · ‎2017-11-30

Hi .

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

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

cristianj23a · ‎2017-11-30

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 · ‎2017-11-30

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.