topic 100% Stacked column chart in QlikView https://community.qlik.com/t5/QlikView/100-Stacked-column-chart/m-p/516188#M550350 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Does anyone know how to create a '100% stacked column' chart in a way, that tool compares the % not to the total, but to the reported groups? I.e.: sum(Product "X")=100%</P><TABLE border="0" cellpadding="0" cellspacing="0" width="514"><TBODY><TR><TD class="xl65" height="20" width="106"> </TD><TD align="left" class="xl65" width="130">Product "X"</TD><TD align="left" class="xl65" width="77">Product "Y"</TD><TD align="left" width="90">Product "Z"</TD><TD align="left" class="xl65" width="111">Grand Total</TD></TR><TR><TD align="left" height="20">Approved</TD><TD align="right" class="xl64">1,427,075</TD><TD align="right" class="xl64">267,717</TD><TD align="right" class="xl64">1,189,907</TD><TD align="right" class="xl64">2,884,699</TD></TR><TR><TD align="left" height="20">Rejected</TD><TD align="right" class="xl64">847,693</TD><TD align="right" class="xl64">765,022</TD><TD align="right" class="xl64">817,593</TD><TD align="right" class="xl64">2,430,308</TD></TR></TBODY></TABLE><P>And is it possible in any way to have both, the values and the % visible in the same chart? Or at least add the values into a % bar chart? Many thanks for your help!</P><P><IMG alt="4.PNG.png" class="jive-image" height="190" src="https://community.qlik.com/legacyfs/online/49837_4.PNG.png" style="width: 373px; height: 190.157px;" width="373" /></P></BODY></HTML> Mon, 02 Dec 2013 16:17:29 GMT 2013-12-02T16:17:29Z 100% Stacked column chart https://community.qlik.com/t5/QlikView/100-Stacked-column-chart/m-p/516188#M550350 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Does anyone know how to create a '100% stacked column' chart in a way, that tool compares the % not to the total, but to the reported groups? I.e.: sum(Product "X")=100%</P><TABLE border="0" cellpadding="0" cellspacing="0" width="514"><TBODY><TR><TD class="xl65" height="20" width="106"> </TD><TD align="left" class="xl65" width="130">Product "X"</TD><TD align="left" class="xl65" width="77">Product "Y"</TD><TD align="left" width="90">Product "Z"</TD><TD align="left" class="xl65" width="111">Grand Total</TD></TR><TR><TD align="left" height="20">Approved</TD><TD align="right" class="xl64">1,427,075</TD><TD align="right" class="xl64">267,717</TD><TD align="right" class="xl64">1,189,907</TD><TD align="right" class="xl64">2,884,699</TD></TR><TR><TD align="left" height="20">Rejected</TD><TD align="right" class="xl64">847,693</TD><TD align="right" class="xl64">765,022</TD><TD align="right" class="xl64">817,593</TD><TD align="right" class="xl64">2,430,308</TD></TR></TBODY></TABLE><P>And is it possible in any way to have both, the values and the % visible in the same chart? Or at least add the values into a % bar chart? Many thanks for your help!</P><P><IMG alt="4.PNG.png" class="jive-image" height="190" src="https://community.qlik.com/legacyfs/online/49837_4.PNG.png" style="width: 373px; height: 190.157px;" width="373" /></P></BODY></HTML> Mon, 02 Dec 2013 16:17:29 GMT https://community.qlik.com/t5/QlikView/100-Stacked-column-chart/m-p/516188#M550350 2013-12-02T16:17:29Z