topic Cumulative percentage in QlikView

topic Cumulative percentage in QlikView https://community.qlik.com/t5/QlikView/Cumulative-percentage/m-p/950924#M969530 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>See table below, column % total cumul.</P><P>Is there a formula that calculates this cumulative % ?</P><P></P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" width="440"><TBODY><TR><TD class="xl63" height="17" width="171">Artikelcode - Omschrijving</TD><TD class="xl71" style="border-left: none;" width="113">Aantal</TD><TD class="xl71" style="border-left: none;" width="63">% total</TD><TD class="xl63" style="border-left: none;" width="93">% total cumul</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;"> </TD><TD align="right" class="xl65" style="border-top: none;">854 155</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">100,00%</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">100,00%</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Artikel 1</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">3 167</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">0,37%</TD><TD align="right" class="xl72">0,37%</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Artikel 2</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">2 157</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">0,25%</TD><TD align="right" class="xl73">0,62%</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Artikel 3</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1 868</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">0,22%</TD><TD align="right" class="xl73">0,84%</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;"><P>…</P></TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD><TD class="xl69" style="border-top: none; border-left: none;"> </TD></TR></TBODY></TABLE></BODY></HTML> Mon, 28 Sep 2015 14:12:40 GMT petermoyaert 2015-09-28T14:12:40Z Cumulative percentage https://community.qlik.com/t5/QlikView/Cumulative-percentage/m-p/950924#M969530 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>See table below, column % total cumul.</P><P>Is there a formula that calculates this cumulative % ?</P><P></P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" width="440"><TBODY><TR><TD class="xl63" height="17" width="171">Artikelcode - Omschrijving</TD><TD class="xl71" style="border-left: none;" width="113">Aantal</TD><TD class="xl71" style="border-left: none;" width="63">% total</TD><TD class="xl63" style="border-left: none;" width="93">% total cumul</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;"> </TD><TD align="right" class="xl65" style="border-top: none;">854 155</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">100,00%</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">100,00%</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Artikel 1</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">3 167</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">0,37%</TD><TD align="right" class="xl72">0,37%</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Artikel 2</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">2 157</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">0,25%</TD><TD align="right" class="xl73">0,62%</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">Artikel 3</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1 868</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">0,22%</TD><TD align="right" class="xl73">0,84%</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;"><P>…</P></TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD><TD class="xl69" style="border-top: none; border-left: none;"> </TD></TR></TBODY></TABLE></BODY></HTML> Mon, 28 Sep 2015 14:12:40 GMT https://community.qlik.com/t5/QlikView/Cumulative-percentage/m-p/950924#M969530 petermoyaert 2015-09-28T14:12:40Z Re: Cumulative percentage https://community.qlik.com/t5/QlikView/Cumulative-percentage/m-p/950925#M969531 <HTML><HEAD></HEAD><BODY><P>You can use the Accumulation option of an expression, just copy the expression and turn it on.</P><P></P><P><IMG alt="Cumulative.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/100243_Cumulative.png" style="height: 530px; width: 620px;" /></P></BODY></HTML> Mon, 28 Sep 2015 14:25:58 GMT https://community.qlik.com/t5/QlikView/Cumulative-percentage/m-p/950925#M969531 stigchel 2015-09-28T14:25:58Z