https://community.qlik.com/t5/App-Development/Cumulative-Percent-Calculation-in-Qliksense-Bar-Chart/m-p/2128105#M91786 <P>Hi,</P> <P>I am having below table as an input:</P> <TABLE style="border-collapse: collapse; width: 247pt;" width="329"> <TBODY> <TR style="height: 15.0pt;"> <TD width="119" height="20" style="width: 89pt; height: 15.0pt;">Company Name</TD> <TD width="64" style="width: 48pt;">Product</TD> <TD width="146" style="width: 110pt;">Vol</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Cloud</TD> <TD class="xl18">A</TD> <TD class="xl21">584</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Star</TD> <TD class="xl18">A</TD> <TD class="xl21">278</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Moon</TD> <TD class="xl18">A</TD> <TD class="xl21">512</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Cloud</TD> <TD class="xl18">B</TD> <TD class="xl21">298</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Star</TD> <TD class="xl18">B</TD> <TD class="xl21">173</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Moon</TD> <TD class="xl18">B</TD> <TD class="xl21">245</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I would like to get the result as % below in bar chart :</P> <TABLE style="border-collapse: collapse; width: 295pt;" width="393"> <TBODY> <TR style="height: 15.0pt;"> <TD width="119" height="20" style="width: 89pt; height: 15.0pt;">Company Name</TD> <TD width="64" style="width: 48pt;">Product</TD> <TD width="146" style="width: 110pt;">Vol</TD> <TD width="64" style="width: 48pt;">% Cal</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Cloud</TD> <TD class="xl18">A</TD> <TD class="xl21">584</TD> <TD align="right">27.93396731</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Star</TD> <TD class="xl18">A</TD> <TD class="xl21">278</TD> <TD align="right">13.2988139</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Moon</TD> <TD class="xl18">A</TD> <TD class="xl21">512</TD> <TD align="right">24.49958667</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Cloud</TD> <TD class="xl18">B</TD> <TD class="xl21">298</TD> <TD align="right">14.26222678</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Star</TD> <TD class="xl18">B</TD> <TD class="xl21">173</TD> <TD align="right">8.279749103</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Moon</TD> <TD class="xl18">B</TD> <TD class="xl21">245</TD> <TD align="right">11.72565624</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Please help with the best possible solution.</P> <P>&nbsp;</P> Fri, 15 Nov 2024 21:20:19 GMT NikitaAgrawal 2024-11-15T21:20:19Z https://community.qlik.com/t5/App-Development/Cumulative-Percent-Calculation-in-Qliksense-Bar-Chart/m-p/2128105#M91786 <P>Hi,</P> <P>I am having below table as an input:</P> <TABLE style="border-collapse: collapse; width: 247pt;" width="329"> <TBODY> <TR style="height: 15.0pt;"> <TD width="119" height="20" style="width: 89pt; height: 15.0pt;">Company Name</TD> <TD width="64" style="width: 48pt;">Product</TD> <TD width="146" style="width: 110pt;">Vol</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Cloud</TD> <TD class="xl18">A</TD> <TD class="xl21">584</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Star</TD> <TD class="xl18">A</TD> <TD class="xl21">278</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Moon</TD> <TD class="xl18">A</TD> <TD class="xl21">512</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Cloud</TD> <TD class="xl18">B</TD> <TD class="xl21">298</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Star</TD> <TD class="xl18">B</TD> <TD class="xl21">173</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Moon</TD> <TD class="xl18">B</TD> <TD class="xl21">245</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I would like to get the result as % below in bar chart :</P> <TABLE style="border-collapse: collapse; width: 295pt;" width="393"> <TBODY> <TR style="height: 15.0pt;"> <TD width="119" height="20" style="width: 89pt; height: 15.0pt;">Company Name</TD> <TD width="64" style="width: 48pt;">Product</TD> <TD width="146" style="width: 110pt;">Vol</TD> <TD width="64" style="width: 48pt;">% Cal</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Cloud</TD> <TD class="xl18">A</TD> <TD class="xl21">584</TD> <TD align="right">27.93396731</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Star</TD> <TD class="xl18">A</TD> <TD class="xl21">278</TD> <TD align="right">13.2988139</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Moon</TD> <TD class="xl18">A</TD> <TD class="xl21">512</TD> <TD align="right">24.49958667</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Cloud</TD> <TD class="xl18">B</TD> <TD class="xl21">298</TD> <TD align="right">14.26222678</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Star</TD> <TD class="xl18">B</TD> <TD class="xl21">173</TD> <TD align="right">8.279749103</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Moon</TD> <TD class="xl18">B</TD> <TD class="xl21">245</TD> <TD align="right">11.72565624</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Please help with the best possible solution.</P> <P>&nbsp;</P> Fri, 15 Nov 2024 21:20:19 GMT https://community.qlik.com/t5/App-Development/Cumulative-Percent-Calculation-in-Qliksense-Bar-Chart/m-p/2128105#M91786 NikitaAgrawal 2024-11-15T21:20:19Z