topic Not show total accumulation data point. in QlikView https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348655#M575743 <HTML><HEAD></HEAD><BODY><P>Something like that <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P></BODY></HTML> Mon, 14 May 2012 21:09:21 GMT Jason_Michaelides 2012-05-14T21:09:21Z Not show total accumulation data point. https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348646#M575734 <HTML><HEAD></HEAD><BODY><P> Don't suppose anyone would know how to not have the total accumulation show at the end of a line in a graph that has full accumulation on and just have the last data points value?&nbsp; I made a target line that is the accumulation of double the actual sales accumulation line.&nbsp; It is linear and is the accumulation of the total accumulation of the sales divided by the number of days times 2.&nbsp; The last day has the correct value but there is another step of accumulation added to the total though there are no more days.&nbsp;&nbsp; Here are the accumulation vales for the last five days with the last number being the total. </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 225pt; border-collapse: collapse;" width="299"><TBODY><TR style="height: 15pt;"><TD align="right" class="xl65" height="20" style="border: 0px black; width: 71pt; height: 15pt; background-color: transparent;" width="95"><SPAN style="font-family: Calibri;">8-May</SPAN></TD><TD align="right" class="xl66" style="border: 0px black; width: 77pt; background-color: transparent;" width="102"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">$83,691,413.35 </SPAN></TD><TD align="right" class="xl66" style="border: 0px black; width: 77pt; background-color: transparent;" width="102"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">$41,738,021.34 </SPAN></TD></TR><TR style="height: 15pt;"><TD align="right" class="xl65" height="20" style="border: 0px black; height: 15pt; background-color: transparent;"><SPAN style="font-family: Calibri;">9-May</SPAN></TD><TD align="right" class="xl66" style="border: 0px black; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">$84,545,407.37 </SPAN></TD><TD align="right" class="xl66" style="border: 0px black; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">$42,157,041.42 </SPAN></TD></TR><TR style="height: 15pt;"><TD align="right" class="xl65" height="20" style="border: 0px black; height: 15pt; background-color: transparent;"><SPAN style="font-family: Calibri;">10-May</SPAN></TD><TD align="right" class="xl66" style="border: 0px black; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">$85,399,401.38 </SPAN></TD><TD align="right" class="xl66" style="border: 0px black; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">$42,699,700.69 </SPAN></TD></TR><TR style="height: 15pt;"><TD align="right" class="xl65" height="20" style="border: 0px black; height: 15pt; background-color: transparent;"><SPAN style="font-family: Calibri;">11-May</SPAN></TD><TD align="right" class="xl66" style="border: 0px black; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">$86,253,395.40 </SPAN></TD><TD align="right" class="xl66" style="border: 0px black; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">$42,699,700.69 </SPAN></TD></TR><TR style="height: 15pt;"><TD height="20" style="border: 0px black; height: 15pt; background-color: transparent;"></TD><TD align="right" class="xl66" style="border: 0px black; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">$87,107,389.41 </SPAN></TD><TD align="right" class="xl66" style="border: 0px black; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">$42,699,700.69 </SPAN></TD></TR></TBODY></TABLE><P>Everything is good except for the total.&nbsp; Any ideas on a fix or is this a bug?</P></BODY></HTML> Fri, 11 May 2012 22:03:11 GMT https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348646#M575734 2012-05-11T22:03:11Z Not show total accumulation data point. https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348647#M575735 <HTML><HEAD></HEAD><BODY><P>Can you post your app?</P></BODY></HTML> Sat, 12 May 2012 05:27:36 GMT https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348647#M575735 Jason_Michaelides 2012-05-12T05:27:36Z Not show total accumulation data point. https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348648#M575736 <HTML><HEAD></HEAD><BODY><P> I got it solved another way.</P></BODY></HTML> Mon, 14 May 2012 19:13:11 GMT https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348648#M575736 2012-05-14T19:13:11Z Not show total accumulation data point. https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348649#M575737 <HTML><HEAD></HEAD><BODY><P>Please post your solution!</P></BODY></HTML> Mon, 14 May 2012 20:37:55 GMT https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348649#M575737 Jason_Michaelides 2012-05-14T20:37:55Z Not show total accumulation data point. https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348650#M575738 <HTML><HEAD></HEAD><BODY><P> =RangeSum(Above(Sum(Sales),0,RowNo())) and offset the number of days divided on with a + 1.&nbsp; This will get you what you want. </P></BODY></HTML> Mon, 14 May 2012 20:42:19 GMT https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348650#M575738 2012-05-14T20:42:19Z Not show total accumulation data point. https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348651#M575739 <HTML><HEAD></HEAD><BODY><P> You answered it in a slightly differntly worded post from me Jason!</P></BODY></HTML> Mon, 14 May 2012 20:42:55 GMT https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348651#M575739 2012-05-14T20:42:55Z Not show total accumulation data point. https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348652#M575740 <HTML><HEAD></HEAD><BODY><P> This question was originally a work around that was solved by an even simpler work-arround stated above.</P></BODY></HTML> Mon, 14 May 2012 20:44:06 GMT https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348652#M575740 2012-05-14T20:44:06Z Not show total accumulation data point. https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348653#M575741 <HTML><HEAD></HEAD><BODY><P>Ah <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 14 May 2012 20:47:32 GMT https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348653#M575741 Jason_Michaelides 2012-05-14T20:47:32Z Not show total accumulation data point. https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348654#M575742 <HTML><HEAD></HEAD><BODY><P>A Starbucks accross from a Starbucks moment?</P></BODY></HTML> Mon, 14 May 2012 21:02:11 GMT https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348654#M575742 2012-05-14T21:02:11Z Not show total accumulation data point. https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348655#M575743 <HTML><HEAD></HEAD><BODY><P>Something like that <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P></BODY></HTML> Mon, 14 May 2012 21:09:21 GMT https://community.qlik.com/t5/QlikView/Not-show-total-accumulation-data-point/m-p/348655#M575743 Jason_Michaelides 2012-05-14T21:09:21Z