topic Re: Percentage by dimension in QlikView https://community.qlik.com/t5/QlikView/Percentage-by-dimension/m-p/420922#M156731 <HTML><HEAD></HEAD><BODY><P>You should use</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum(Unidades)/Sum(total &lt;Año&gt; Unidades)</P><P>as formula.</P><P></P><P>Further, you need to uncheck Expressions-&gt;Relative. You should probably also format the number as "Integer" and "Show in Percent".</P><P></P><P>HIC</P><P></P><P><IMG __jive_id="40317" class="jive-image" alt="Total Porc.png" src="/legacyfs/online/40317_Total Porc.png" /></P></BODY></HTML> Thu, 02 May 2013 15:16:47 GMT hic 2013-05-02T15:16:47Z Percentage by dimension https://community.qlik.com/t5/QlikView/Percentage-by-dimension/m-p/420921#M156730 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P><SPAN class="hps">I have a</SPAN> <SPAN class="hps">table with the following</SPAN> <SPAN class="hps">data</SPAN>, year, <SPAN class="hps">origin</SPAN> <SPAN class="hps">and quantity.</SPAN></P><P><SPAN class="hps">I need to know</SPAN> <SPAN class="hps">the percentage</SPAN> <SPAN class="hps">per year, but</SPAN> <SPAN class="hps">not on the total</SPAN>, <SPAN class="hps">but</SPAN> <SPAN class="hps">show me</SPAN> <SPAN class="hps">each year.</SPAN></P><P><SPAN class="hps">File</SPAN> <SPAN class="hps">Attachment</SPAN>. <SPAN class="hps">Thank you.</SPAN></P><P><SPAN class="hps"></SPAN></P><P><SPAN class="hps"><IMG __jive_id="40319" class="jive-image-thumbnail jive-image" onclick="" alt="Captura.PNG" src="https://community.qlik.com/legacyfs/online/40319_Captura.PNG" width="450" /></SPAN></P><P><SPAN class="hps">Regards.</SPAN></P></BODY></HTML> Thu, 02 May 2013 15:07:09 GMT https://community.qlik.com/t5/QlikView/Percentage-by-dimension/m-p/420921#M156730 spividori 2013-05-02T15:07:09Z Re: Percentage by dimension https://community.qlik.com/t5/QlikView/Percentage-by-dimension/m-p/420922#M156731 <HTML><HEAD></HEAD><BODY><P>You should use</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum(Unidades)/Sum(total &lt;Año&gt; Unidades)</P><P>as formula.</P><P></P><P>Further, you need to uncheck Expressions-&gt;Relative. You should probably also format the number as "Integer" and "Show in Percent".</P><P></P><P>HIC</P><P></P><P><IMG __jive_id="40317" class="jive-image" alt="Total Porc.png" src="/legacyfs/online/40317_Total Porc.png" /></P></BODY></HTML> Thu, 02 May 2013 15:16:47 GMT https://community.qlik.com/t5/QlikView/Percentage-by-dimension/m-p/420922#M156731 hic 2013-05-02T15:16:47Z Re: Percentage by dimension https://community.qlik.com/t5/QlikView/Percentage-by-dimension/m-p/420923#M156732 <HTML><HEAD></HEAD><BODY><P>Hi Henric.</P><P><SPAN class="hps">Thank you very much</SPAN>, <SPAN class="hps">is</SPAN> <SPAN class="hps">what I needed</SPAN>.</P><P>Regards.</P></BODY></HTML> Thu, 02 May 2013 15:39:04 GMT https://community.qlik.com/t5/QlikView/Percentage-by-dimension/m-p/420923#M156732 spividori 2013-05-02T15:39:04Z