topic Pivot Chart in QlikView https://community.qlik.com/t5/QlikView/Pivot-Chart/m-p/468240#M174856 <HTML><HEAD></HEAD><BODY><P>icreated pivot chart , i am using two dimension category and Month and expression sum(Visit).</P><P>i want to calcilate relative % as second expression but in pivot there is no option for realtive calculation</P><P>please suggest how to achive this in pivot chart.</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 206px;"><TBODY><TR><TD height="20" width="64">category</TD><TD width="78">Month</TD><TD width="64">Visit</TD></TR><TR><TD height="20">abc</TD><TD>jan</TD><TD align="right">10</TD></TR><TR><TD height="20">abs</TD><TD>jan</TD><TD align="right">10</TD></TR><TR><TD height="20">cds</TD><TD>jan</TD><TD align="right">10</TD></TR><TR><TD height="20">hty</TD><TD>jan</TD><TD align="right">10</TD></TR><TR><TD height="20">asd</TD><TD>jan</TD><TD align="right">50</TD></TR><TR><TD height="20">abc</TD><TD>Feb</TD><TD align="right">20</TD></TR><TR><TD height="20">abs</TD><TD>Feb</TD><TD align="right">30</TD></TR><TR><TD height="20">cds</TD><TD>Feb</TD><TD align="right">30</TD></TR><TR><TD height="20">hty</TD><TD>Feb</TD><TD align="right">30</TD></TR><TR><TD height="20">asd</TD><TD>Feb</TD><TD align="right">30</TD></TR><TR><TD height="20">ghj</TD><TD>Mar</TD><TD align="right">120</TD></TR><TR><TD height="20">jkl</TD><TD>Mar</TD><TD align="right">80</TD></TR><TR><TD height="20">hut</TD><TD>Mar</TD><TD align="right">430</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 26 Nov 2012 21:27:28 GMT 2012-11-26T21:27:28Z Pivot Chart https://community.qlik.com/t5/QlikView/Pivot-Chart/m-p/468240#M174856 <HTML><HEAD></HEAD><BODY><P>icreated pivot chart , i am using two dimension category and Month and expression sum(Visit).</P><P>i want to calcilate relative % as second expression but in pivot there is no option for realtive calculation</P><P>please suggest how to achive this in pivot chart.</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 206px;"><TBODY><TR><TD height="20" width="64">category</TD><TD width="78">Month</TD><TD width="64">Visit</TD></TR><TR><TD height="20">abc</TD><TD>jan</TD><TD align="right">10</TD></TR><TR><TD height="20">abs</TD><TD>jan</TD><TD align="right">10</TD></TR><TR><TD height="20">cds</TD><TD>jan</TD><TD align="right">10</TD></TR><TR><TD height="20">hty</TD><TD>jan</TD><TD align="right">10</TD></TR><TR><TD height="20">asd</TD><TD>jan</TD><TD align="right">50</TD></TR><TR><TD height="20">abc</TD><TD>Feb</TD><TD align="right">20</TD></TR><TR><TD height="20">abs</TD><TD>Feb</TD><TD align="right">30</TD></TR><TR><TD height="20">cds</TD><TD>Feb</TD><TD align="right">30</TD></TR><TR><TD height="20">hty</TD><TD>Feb</TD><TD align="right">30</TD></TR><TR><TD height="20">asd</TD><TD>Feb</TD><TD align="right">30</TD></TR><TR><TD height="20">ghj</TD><TD>Mar</TD><TD align="right">120</TD></TR><TR><TD height="20">jkl</TD><TD>Mar</TD><TD align="right">80</TD></TR><TR><TD height="20">hut</TD><TD>Mar</TD><TD align="right">430</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 26 Nov 2012 21:27:28 GMT https://community.qlik.com/t5/QlikView/Pivot-Chart/m-p/468240#M174856 2012-11-26T21:27:28Z Re: Pivot Chart https://community.qlik.com/t5/QlikView/Pivot-Chart/m-p/468241#M174857 <HTML><HEAD></HEAD><BODY><P>Depending on what you mean by "relative", it may be one of these, or something similar:</P><P><BR />sum(Visit)/sum(total Visit)<BR />or <BR />sum(Visit)/sum(total&lt;Month&gt; Visit)<BR />or<BR />sum(Visit)/sum(total&lt;category&gt; Visit)</P><P></P><P>Regards,<BR />Michael</P></BODY></HTML> Mon, 26 Nov 2012 21:38:25 GMT https://community.qlik.com/t5/QlikView/Pivot-Chart/m-p/468241#M174857 Anonymous 2012-11-26T21:38:25Z