topic Resident in QlikView https://community.qlik.com/t5/QlikView/Resident/m-p/1408297#M800561 <HTML><HEAD></HEAD><BODY><P>Hi .</P><P>Help me identify what is wrong with the code because I get an error message that says "invalid expression".</P><P><IMG alt="NoConsiderado.PNG" class="jive-image image-1" height="284" src="https://community.qlik.com/legacyfs/online/185336_NoConsiderado.PNG" style="height: 284px; width: 1083.11px;" width="1083" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT cristianj23a 2020-11-25T16:16:04Z Resident https://community.qlik.com/t5/QlikView/Resident/m-p/1408297#M800561 <HTML><HEAD></HEAD><BODY><P>Hi .</P><P>Help me identify what is wrong with the code because I get an error message that says "invalid expression".</P><P><IMG alt="NoConsiderado.PNG" class="jive-image image-1" height="284" src="https://community.qlik.com/legacyfs/online/185336_NoConsiderado.PNG" style="height: 284px; width: 1083.11px;" width="1083" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Resident/m-p/1408297#M800561 cristianj23a 2020-11-25T16:16:04Z Re: Resident https://community.qlik.com/t5/QlikView/Resident/m-p/1408298#M800562 <HTML><HEAD></HEAD><BODY><P>check the fields first --&gt; red color...</P></BODY></HTML> Thu, 30 Nov 2017 18:18:50 GMT https://community.qlik.com/t5/QlikView/Resident/m-p/1408298#M800562 Anonymous 2017-11-30T18:18:50Z Re: Resident https://community.qlik.com/t5/QlikView/Resident/m-p/1408299#M800563 <HTML><HEAD></HEAD><BODY><P>Hi Robin.</P><P>The fields do exist in the table</P></BODY></HTML> Thu, 30 Nov 2017 18:26:45 GMT https://community.qlik.com/t5/QlikView/Resident/m-p/1408299#M800563 cristianj23a 2017-11-30T18:26:45Z Re: Resident https://community.qlik.com/t5/QlikView/Resident/m-p/1408300#M800564 <HTML><HEAD></HEAD><BODY><P>then please post the error message and copy your screenshot as text ...</P></BODY></HTML> Thu, 30 Nov 2017 18:30:14 GMT https://community.qlik.com/t5/QlikView/Resident/m-p/1408300#M800564 Anonymous 2017-11-30T18:30:14Z Re: Resident https://community.qlik.com/t5/QlikView/Resident/m-p/1408301#M800565 <HTML><HEAD></HEAD><BODY><P>Missing a closing parenthesis on the big if statement.</P></BODY></HTML> Thu, 30 Nov 2017 19:24:24 GMT https://community.qlik.com/t5/QlikView/Resident/m-p/1408301#M800565 Anonymous 2017-11-30T19:24:24Z Re: Resident https://community.qlik.com/t5/QlikView/Resident/m-p/1408302#M800566 <HTML><HEAD></HEAD><BODY><P>it's really hard finding the problem with the help of a screenshot <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 30 Nov 2017 19:26:07 GMT https://community.qlik.com/t5/QlikView/Resident/m-p/1408302#M800566 Anonymous 2017-11-30T19:26:07Z Re: Resident https://community.qlik.com/t5/QlikView/Resident/m-p/1408303#M800567 <HTML><HEAD></HEAD><BODY><P>There is.</P><P><IMG alt="Scrpt02.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/185345_Scrpt02.PNG" style="height: 337px; width: 620px;" /></P><P>regards</P></BODY></HTML> Thu, 30 Nov 2017 19:30:36 GMT https://community.qlik.com/t5/QlikView/Resident/m-p/1408303#M800567 cristianj23a 2017-11-30T19:30:36Z Re: Resident https://community.qlik.com/t5/QlikView/Resident/m-p/1408304#M800568 <HTML><HEAD></HEAD><BODY><P>The first table if loading, from the resident the error comes out.</P></BODY></HTML> Thu, 30 Nov 2017 19:31:59 GMT https://community.qlik.com/t5/QlikView/Resident/m-p/1408304#M800568 cristianj23a 2017-11-30T19:31:59Z Re: Resident https://community.qlik.com/t5/QlikView/Resident/m-p/1408305#M800569 <HTML><HEAD></HEAD><BODY><P>True.</P><P>I do not upload the qvd because it weighs a lot. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Thu, 30 Nov 2017 19:33:08 GMT https://community.qlik.com/t5/QlikView/Resident/m-p/1408305#M800569 cristianj23a 2017-11-30T19:33:08Z Re: Resident https://community.qlik.com/t5/QlikView/Resident/m-p/1408306#M800570 <HTML><HEAD></HEAD><BODY><P>can't use a Sum without a Group By</P></BODY></HTML> Thu, 30 Nov 2017 19:33:23 GMT https://community.qlik.com/t5/QlikView/Resident/m-p/1408306#M800570 Anonymous 2017-11-30T19:33:23Z Re: Resident https://community.qlik.com/t5/QlikView/Resident/m-p/1408307#M800571 <HTML><HEAD></HEAD><BODY><P>Is there any way to sum but without grouping?</P></BODY></HTML> Fri, 01 Dec 2017 02:20:44 GMT https://community.qlik.com/t5/QlikView/Resident/m-p/1408307#M800571 cristianj23a 2017-12-01T02:20:44Z Re: Resident https://community.qlik.com/t5/QlikView/Resident/m-p/1408308#M800572 <HTML><HEAD></HEAD><BODY><P>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. </P></BODY></HTML> Fri, 01 Dec 2017 03:35:24 GMT https://community.qlik.com/t5/QlikView/Resident/m-p/1408308#M800572 vishsaggi 2017-12-01T03:35:24Z