topic Re: Cummulitive sums in QlikView https://community.qlik.com/t5/QlikView/Cummulitive-sums/m-p/54829#M767175 <HTML><HEAD></HEAD><BODY><P>The final table won't have Date? just MonthName and CumulativeSUM?</P></BODY></HTML> Wed, 20 Jun 2018 12:40:32 GMT sunny_talwar 2018-06-20T12:40:32Z Cummulitive sums https://community.qlik.com/t5/QlikView/Cummulitive-sums/m-p/54828#M767174 <HTML><HEAD></HEAD><BODY><P>I have table data:</P><P></P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MonthName</P><P>10.02.2017&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; feb 2017</P><P>15.02.2017&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; feb 2017</P><P>09.05.2017&nbsp;&nbsp;&nbsp;&nbsp; 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may 2017</P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Date,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Value,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; MonthName</P><P>Resident SQL_Table</P><P></P><P></P><P>I need to get aggregated cumulative SUM for each monthName, like this:</P><P></P><P style="font-size: 13.3333px;">MonthName&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CumulativeSUM</P><P style="font-size: 13.3333px;"> feb 2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24&nbsp; //for all months before March</P><P style="font-size: 13.3333px;"> may 2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45 // for all months before June</P><P></P><P>How can I reLOAD in order to get such data?</P><P></P><P>Thank you in advance!!</P><P></P><P></P><P></P><P>P.S.:sorry for third topic within the day</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Cummulitive-sums/m-p/54828#M767174 sculptorlv 2020-11-25T16:16:04Z Re: Cummulitive sums https://community.qlik.com/t5/QlikView/Cummulitive-sums/m-p/54829#M767175 <HTML><HEAD></HEAD><BODY><P>The final table won't have Date? just MonthName and CumulativeSUM?</P></BODY></HTML> Wed, 20 Jun 2018 12:40:32 GMT https://community.qlik.com/t5/QlikView/Cummulitive-sums/m-p/54829#M767175 sunny_talwar 2018-06-20T12:40:32Z Re: Cummulitive sums https://community.qlik.com/t5/QlikView/Cummulitive-sums/m-p/54830#M767176 <HTML><HEAD></HEAD><BODY><P>There is another field - Source_Type (like Cars, Aircrafts, Boats etc)</P></BODY></HTML> Wed, 20 Jun 2018 12:41:54 GMT https://community.qlik.com/t5/QlikView/Cummulitive-sums/m-p/54830#M767176 sculptorlv 2018-06-20T12:41:54Z Re: Cummulitive sums https://community.qlik.com/t5/QlikView/Cummulitive-sums/m-p/54831#M767177 <HTML><HEAD></HEAD><BODY><P>But the final table won't have Date, right? Accumulation is for Each Source_Type and restarts when Source_Type changes?</P></BODY></HTML> Wed, 20 Jun 2018 13:26:00 GMT https://community.qlik.com/t5/QlikView/Cummulitive-sums/m-p/54831#M767177 sunny_talwar 2018-06-20T13:26:00Z Re: Cummulitive sums https://community.qlik.com/t5/QlikView/Cummulitive-sums/m-p/54832#M767178 <HTML><HEAD></HEAD><BODY><P>Yes, sure. No particular dates (like 14.06.2017), but only monthnames</P></BODY></HTML> Wed, 20 Jun 2018 13:29:17 GMT https://community.qlik.com/t5/QlikView/Cummulitive-sums/m-p/54832#M767178 sculptorlv 2018-06-20T13:29:17Z