topic Partial Accumulation in table in QlikView https://community.qlik.com/t5/QlikView/Partial-Accumulation-in-table/m-p/398357#M569327 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="23218" class="jive-image-thumbnail jive-image" height="243" onclick="" alt="table.JPG" src="https://community.qlik.com/legacyfs/online/23218_table.JPG" width="525" /></P><P></P><P>I am trying to do a partial accumulation on the spend column (column 3) - I have a full years budget column(1) and want the plot spend so far against it, if I use full acculualation (column 6) I end up with a static figures for months that haven't happened yet. I tried using the above function (column 5) but ended up with strange figures. Any suggestions?</P><P></P><P>The set analysis i'm using forthe buget, spend etc. is as follows:-</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; sum<SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">BER_DeaTran_Period_Name</SPAN><SPAN style="font-size: 8pt;">=&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">BER_DeaTran_Current_Budget</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P></P><P>Thanks in advance.</P><P></P><P>Stephen</P></BODY></HTML> Wed, 10 Oct 2012 10:16:27 GMT 2012-10-10T10:16:27Z Partial Accumulation in table https://community.qlik.com/t5/QlikView/Partial-Accumulation-in-table/m-p/398357#M569327 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="23218" class="jive-image-thumbnail jive-image" height="243" onclick="" alt="table.JPG" src="https://community.qlik.com/legacyfs/online/23218_table.JPG" width="525" /></P><P></P><P>I am trying to do a partial accumulation on the spend column (column 3) - I have a full years budget column(1) and want the plot spend so far against it, if I use full acculualation (column 6) I end up with a static figures for months that haven't happened yet. I tried using the above function (column 5) but ended up with strange figures. Any suggestions?</P><P></P><P>The set analysis i'm using forthe buget, spend etc. is as follows:-</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; sum<SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">BER_DeaTran_Period_Name</SPAN><SPAN style="font-size: 8pt;">=&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">BER_DeaTran_Current_Budget</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P></P><P>Thanks in advance.</P><P></P><P>Stephen</P></BODY></HTML> Wed, 10 Oct 2012 10:16:27 GMT https://community.qlik.com/t5/QlikView/Partial-Accumulation-in-table/m-p/398357#M569327 2012-10-10T10:16:27Z