topic How to avoid aggregate in expression ? in QlikView https://community.qlik.com/t5/QlikView/How-to-avoid-aggregate-in-expression/m-p/1173812#M633987 <HTML><HEAD></HEAD><BODY><P>‌Hi All</P><P></P><P>In order to solve my problem , I need to make use of aggregate function in my expression.</P><P></P><P>but i am not able to completely solve it. For example I can get YTD amount but I am not able get the LY YTD amount correct.</P><P></P><P>My question is it is possible using aggregate in partial reload script , this way I can avoid it in expression . Can some one advise me ?</P><P></P><P>PAul</P></BODY></HTML> Sat, 11 Jun 2016 19:26:49 GMT paulyeo11 2016-06-11T19:26:49Z How to avoid aggregate in expression ? https://community.qlik.com/t5/QlikView/How-to-avoid-aggregate-in-expression/m-p/1173812#M633987 <HTML><HEAD></HEAD><BODY><P>‌Hi All</P><P></P><P>In order to solve my problem , I need to make use of aggregate function in my expression.</P><P></P><P>but i am not able to completely solve it. For example I can get YTD amount but I am not able get the LY YTD amount correct.</P><P></P><P>My question is it is possible using aggregate in partial reload script , this way I can avoid it in expression . Can some one advise me ?</P><P></P><P>PAul</P></BODY></HTML> Sat, 11 Jun 2016 19:26:49 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-aggregate-in-expression/m-p/1173812#M633987 paulyeo11 2016-06-11T19:26:49Z Re: How to avoid aggregate in expression ? https://community.qlik.com/t5/QlikView/How-to-avoid-aggregate-in-expression/m-p/1173813#M633988 <HTML><HEAD></HEAD><BODY><P>I have not understood what your issue is, but you should be able to use a GROUP BY clause in a LOAD statement with aggregation functions also in a partial reload (using the ADD or REPLACE LOAD prefix).</P></BODY></HTML> Sat, 11 Jun 2016 22:31:32 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-aggregate-in-expression/m-p/1173813#M633988 swuehl 2016-06-11T22:31:32Z Re: How to avoid aggregate in expression ? https://community.qlik.com/t5/QlikView/How-to-avoid-aggregate-in-expression/m-p/1173814#M633989 <HTML><HEAD></HEAD><BODY><P>‌Hi Stefan</P><P></P><P>thank you for your sharing , I will try it .</P><P></P><P>PAul</P></BODY></HTML> Sun, 12 Jun 2016 10:32:29 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-aggregate-in-expression/m-p/1173814#M633989 paulyeo11 2016-06-12T10:32:29Z