topic Re: Aggregation in QlikView https://community.qlik.com/t5/QlikView/Aggregation/m-p/753624#M473508 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Mon, 03 Nov 2014 10:57:03 GMT Gysbert_Wassenaar 2014-11-03T10:57:03Z Aggregation https://community.qlik.com/t5/QlikView/Aggregation/m-p/753622#M473506 <HTML><HEAD></HEAD><BODY><P>Hi community!</P><P></P><P>Consider the attached file.</P><P></P><P>I want to present an <STRONG>accumulated</STRONG> graph&nbsp; which plots the accumulated balance for the periods less than the selected month pluss the prognosis for the rest of the periods. All in one line, a dotted prognosis line would be nice.</P><P></P><P>Pls advice!</P><P></P><P>Best regards</P><P>Trond Erik</P></BODY></HTML> Mon, 03 Nov 2014 10:32:50 GMT https://community.qlik.com/t5/QlikView/Aggregation/m-p/753622#M473506 2014-11-03T10:32:50Z Re: Aggregation https://community.qlik.com/t5/QlikView/Aggregation/m-p/753623#M473507 <HTML><HEAD></HEAD><BODY><P>Like this?</P></BODY></HTML> Mon, 03 Nov 2014 10:52:38 GMT https://community.qlik.com/t5/QlikView/Aggregation/m-p/753623#M473507 MK_QSL 2014-11-03T10:52:38Z Re: Aggregation https://community.qlik.com/t5/QlikView/Aggregation/m-p/753624#M473508 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Mon, 03 Nov 2014 10:57:03 GMT https://community.qlik.com/t5/QlikView/Aggregation/m-p/753624#M473508 Gysbert_Wassenaar 2014-11-03T10:57:03Z Re: Aggregation https://community.qlik.com/t5/QlikView/Aggregation/m-p/753625#M473509 <HTML><HEAD></HEAD><BODY><P>Thx guys!</P><P></P><P>Gysbert, you are almost right. But you are only aggregating the Balance. The plot is flat the last few periods.</P><P></P><P>Also: How can I do this without using the accumulate function on the graph properties?</P><P></P><P>Best regards</P><P>Trond E</P></BODY></HTML> Mon, 03 Nov 2014 12:12:42 GMT https://community.qlik.com/t5/QlikView/Aggregation/m-p/753625#M473509 2014-11-03T12:12:42Z Re: Aggregation https://community.qlik.com/t5/QlikView/Aggregation/m-p/753626#M473510 <HTML><HEAD></HEAD><BODY><P>See this document: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Mon, 03 Nov 2014 12:28:09 GMT https://community.qlik.com/t5/QlikView/Aggregation/m-p/753626#M473510 Gysbert_Wassenaar 2014-11-03T12:28:09Z