topic Re: Calculate accumulated values in QlikView https://community.qlik.com/t5/QlikView/Calculate-accumulated-values/m-p/1335965#M515502 <HTML><HEAD></HEAD><BODY><P>Many thank. How can I create a 100% stacked bar chart?<IMG alt="AccumulatedValue01.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163199_AccumulatedValue01.JPG" style="width: 620px; height: 187px;" /></P></BODY></HTML> Fri, 12 May 2017 14:50:00 GMT Anonymous 2017-05-12T14:50:00Z Calculate accumulated values https://community.qlik.com/t5/QlikView/Calculate-accumulated-values/m-p/1335961#M515498 <HTML><HEAD></HEAD><BODY><P></P><P><SPAN style="mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 11.0pt; color: #000000; font-size: 10pt; mso-ansi-language: EN-US; font-family: 'Arial','sans-serif'; mso-bidi-theme-font: minor-bidi;">Hello,</SPAN></P><P></P><P><SPAN style="mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 11.0pt; color: #000000; font-size: 10pt; mso-ansi-language: EN-US; font-family: 'Arial','sans-serif'; mso-bidi-theme-font: minor-bidi;">in a table accumulated values should be calculated. The column Proj contains accumulated values.</SPAN><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> How can column Test calculated?</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 11.0pt; color: #000000; font-size: 10pt; mso-ansi-language: EN-US; font-family: 'Arial','sans-serif'; mso-bidi-theme-font: minor-bidi;">The following formula have no function (Column (1)-Column (2))</SPAN></P><P></P><P></P><P><SPAN style="mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 11.0pt; color: #000000; font-size: 10pt; mso-ansi-language: EN-US; font-family: 'Arial','sans-serif'; mso-bidi-theme-font: minor-bidi;">Regards Stefan</SPAN></P></BODY></HTML> Fri, 12 May 2017 13:59:08 GMT https://community.qlik.com/t5/QlikView/Calculate-accumulated-values/m-p/1335961#M515498 Anonymous 2017-05-12T13:59:08Z Re: Calculate accumulated values https://community.qlik.com/t5/QlikView/Calculate-accumulated-values/m-p/1335962#M515499 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Column(1)-RangeSum(Above(Proj, 0, RowNo()))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163191_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Fri, 12 May 2017 14:07:21 GMT https://community.qlik.com/t5/QlikView/Calculate-accumulated-values/m-p/1335962#M515499 sunny_talwar 2017-05-12T14:07:21Z Re: Calculate accumulated values https://community.qlik.com/t5/QlikView/Calculate-accumulated-values/m-p/1335963#M515500 <HTML><HEAD></HEAD><BODY><P>Use this</P><P></P><P> sum(Prod)-sum(Proj)</P></BODY></HTML> Fri, 12 May 2017 14:08:51 GMT https://community.qlik.com/t5/QlikView/Calculate-accumulated-values/m-p/1335963#M515500 Kushal_Chawda 2017-05-12T14:08:51Z Re: Calculate accumulated values https://community.qlik.com/t5/QlikView/Calculate-accumulated-values/m-p/1335964#M515501 <HTML><HEAD></HEAD><BODY><P>Or change your second expression to be this</P><P><STRONG>RangeSum(Above(Proj, 0, RowNo()))</STRONG></P><P></P><P>with no accumulation selected</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163192_Capture.PNG" style="height: 144px; width: 620px;" /></P></BODY></HTML> Fri, 12 May 2017 14:10:54 GMT https://community.qlik.com/t5/QlikView/Calculate-accumulated-values/m-p/1335964#M515501 sunny_talwar 2017-05-12T14:10:54Z Re: Calculate accumulated values https://community.qlik.com/t5/QlikView/Calculate-accumulated-values/m-p/1335965#M515502 <HTML><HEAD></HEAD><BODY><P>Many thank. How can I create a 100% stacked bar chart?<IMG alt="AccumulatedValue01.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163199_AccumulatedValue01.JPG" style="width: 620px; height: 187px;" /></P></BODY></HTML> Fri, 12 May 2017 14:50:00 GMT https://community.qlik.com/t5/QlikView/Calculate-accumulated-values/m-p/1335965#M515502 Anonymous 2017-05-12T14:50:00Z Re: Calculate accumulated values https://community.qlik.com/t5/QlikView/Calculate-accumulated-values/m-p/1335966#M515503 <HTML><HEAD></HEAD><BODY><P>What is the logic? Can you share the expected percentage in Excel file?</P></BODY></HTML> Fri, 12 May 2017 15:19:37 GMT https://community.qlik.com/t5/QlikView/Calculate-accumulated-values/m-p/1335966#M515503 sunny_talwar 2017-05-12T15:19:37Z