topic Re: sum and aggr in QlikView https://community.qlik.com/t5/QlikView/sum-and-aggr/m-p/1066790#M929656 <HTML><HEAD></HEAD><BODY><P>Hi, attached you have an example.</P></BODY></HTML> Mon, 14 Mar 2016 16:53:51 GMT ecolomer 2016-03-14T16:53:51Z sum and aggr https://community.qlik.com/t5/QlikView/sum-and-aggr/m-p/1066789#M929655 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>&nbsp; I don't know how to combine sum and aggr function in my set analysis expression.</P><P>&nbsp; I need help to find the right expression syntax to get the correct result.</P><P></P><P>&nbsp;&nbsp; I give an exemple of my chart expression ( t6 ).</P><P></P><P>Sum({&lt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; D_Date_Histo={"$(=</P><P>&nbsp;&nbsp;&nbsp; </P><P>&nbsp; Aggr(</P><P>&nbsp; only(date(date(D_Date_Time+State_Day_Value)&amp;' '&amp;MakeTime(State_Time_Value),'DD/MM/YYYY hh'))</P><P>&nbsp; ,D_Date_Time</P><P>&nbsp; )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )"}</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &gt;} D_LastPRVValue)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/sum-and-aggr/m-p/1066789#M929655 lionel_t 2020-11-25T16:16:04Z Re: sum and aggr https://community.qlik.com/t5/QlikView/sum-and-aggr/m-p/1066790#M929656 <HTML><HEAD></HEAD><BODY><P>Hi, attached you have an example.</P></BODY></HTML> Mon, 14 Mar 2016 16:53:51 GMT https://community.qlik.com/t5/QlikView/sum-and-aggr/m-p/1066790#M929656 ecolomer 2016-03-14T16:53:51Z Re: sum and aggr https://community.qlik.com/t5/QlikView/sum-and-aggr/m-p/1066791#M929657 <HTML><HEAD></HEAD><BODY><P>You can change Avg with Sum, because are same type of function</P></BODY></HTML> Mon, 14 Mar 2016 16:55:25 GMT https://community.qlik.com/t5/QlikView/sum-and-aggr/m-p/1066791#M929657 ecolomer 2016-03-14T16:55:25Z Re: sum and aggr https://community.qlik.com/t5/QlikView/sum-and-aggr/m-p/1066792#M929658 <HTML><HEAD></HEAD><BODY><P>See this:</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-12703" title="https://community.qlik.com/docs/DOC-12703">https://community.qlik.com/docs/DOC-12703</A></P></BODY></HTML> Mon, 14 Mar 2016 16:57:25 GMT https://community.qlik.com/t5/QlikView/sum-and-aggr/m-p/1066792#M929658 ecolomer 2016-03-14T16:57:25Z