topic Proportion Query in QlikView https://community.qlik.com/t5/QlikView/Proportion-Query/m-p/12901#M2117 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a question on proportion. </P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 195px;"><TBODY><TR><TD height="20" width="64">Company</TD><TD width="67">Levers</TD><TD width="64">Value</TD></TR><TR><TD height="20">a</TD><TD>Sales</TD><TD align="right">2</TD></TR><TR><TD height="20">a</TD><TD>Discounts</TD><TD align="right">4</TD></TR><TR><TD height="20">a</TD><TD>Expenses</TD><TD align="right">10</TD></TR><TR><TD height="20">b</TD><TD>Sales</TD><TD align="right">12</TD></TR><TR><TD height="20">b</TD><TD>Discounts</TD><TD align="right">8</TD></TR><TR><TD height="20">b</TD><TD>Expenses</TD><TD align="right">9</TD></TR><TR><TD height="20">c</TD><TD>Expenses</TD><TD align="right">15</TD></TR></TBODY></TABLE><P></P><P>Need to calculate the below Parameter (what is the expression?)</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="330"><TBODY><TR><TD height="20" width="64">Company</TD><TD width="202">Metric</TD></TR><TR><TD height="20">a</TD><TD>= Expenses of <SPAN class="font5">a</SPAN><SPAN class="font0"> / Expenses of </SPAN><SPAN class="font6">c</SPAN></TD><TD>=10/15</TD></TR><TR><TD height="20">b</TD><TD>= Expenses of <SPAN class="font5">b</SPAN><SPAN class="font0"> / Expenses of </SPAN><SPAN class="font6">c</SPAN></TD><TD><P>=9/15</P><P></P><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌</P></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 10 Apr 2018 14:06:00 GMT narayanamsn 2018-04-10T14:06:00Z Proportion Query https://community.qlik.com/t5/QlikView/Proportion-Query/m-p/12901#M2117 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a question on proportion. </P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 195px;"><TBODY><TR><TD height="20" width="64">Company</TD><TD width="67">Levers</TD><TD width="64">Value</TD></TR><TR><TD height="20">a</TD><TD>Sales</TD><TD align="right">2</TD></TR><TR><TD height="20">a</TD><TD>Discounts</TD><TD align="right">4</TD></TR><TR><TD height="20">a</TD><TD>Expenses</TD><TD align="right">10</TD></TR><TR><TD height="20">b</TD><TD>Sales</TD><TD align="right">12</TD></TR><TR><TD height="20">b</TD><TD>Discounts</TD><TD align="right">8</TD></TR><TR><TD height="20">b</TD><TD>Expenses</TD><TD align="right">9</TD></TR><TR><TD height="20">c</TD><TD>Expenses</TD><TD align="right">15</TD></TR></TBODY></TABLE><P></P><P>Need to calculate the below Parameter (what is the expression?)</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="330"><TBODY><TR><TD height="20" width="64">Company</TD><TD width="202">Metric</TD></TR><TR><TD height="20">a</TD><TD>= Expenses of <SPAN class="font5">a</SPAN><SPAN class="font0"> / Expenses of </SPAN><SPAN class="font6">c</SPAN></TD><TD>=10/15</TD></TR><TR><TD height="20">b</TD><TD>= Expenses of <SPAN class="font5">b</SPAN><SPAN class="font0"> / Expenses of </SPAN><SPAN class="font6">c</SPAN></TD><TD><P>=9/15</P><P></P><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌</P></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 10 Apr 2018 14:06:00 GMT https://community.qlik.com/t5/QlikView/Proportion-Query/m-p/12901#M2117 narayanamsn 2018-04-10T14:06:00Z Re: Proportion Query https://community.qlik.com/t5/QlikView/Proportion-Query/m-p/12902#M2118 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P>Dimension</P><P><STRONG>Company</STRONG></P><P></P><P>Expression</P><P><STRONG>Sum({&lt;Levers = {'Expenses'}&gt;}Value)/Sum(TOTAL {&lt;Levers = {'Expenses'}, Company = {'C'}&gt;}Value)</STRONG></P></BODY></HTML> Tue, 10 Apr 2018 14:09:49 GMT https://community.qlik.com/t5/QlikView/Proportion-Query/m-p/12902#M2118 sunny_talwar 2018-04-10T14:09:49Z Re: Proportion Query https://community.qlik.com/t5/QlikView/Proportion-Query/m-p/12903#M2119 <HTML><HEAD></HEAD><BODY><P>How to add any date filter if I have ..</P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="394"><TBODY><TR><TD height="20" width="64">Company</TD><TD width="202">Levers</TD><TD width="64">Value</TD><TD width="64">Month</TD></TR><TR><TD height="20">a</TD><TD>Sales</TD><TD align="right">2</TD><TD align="right">1</TD></TR><TR><TD height="20">a</TD><TD>Discounts</TD><TD align="right">4</TD><TD align="right">1</TD></TR><TR><TD height="20">a</TD><TD>Expenses</TD><TD align="right">10</TD><TD align="right">1</TD></TR><TR><TD height="20">b</TD><TD>Sales</TD><TD align="right">12</TD><TD align="right">1</TD></TR><TR><TD height="20">b</TD><TD>Discounts</TD><TD align="right">8</TD><TD align="right">1</TD></TR><TR><TD height="20">b</TD><TD>Expenses</TD><TD align="right">9</TD><TD align="right">1</TD></TR><TR><TD height="20">c</TD><TD>Expenses</TD><TD align="right">15</TD><TD align="right">1</TD></TR><TR><TD height="20">a</TD><TD>Sales</TD><TD align="right">10</TD><TD align="right">2</TD></TR><TR><TD height="20">a</TD><TD>Discounts</TD><TD align="right">2</TD><TD align="right">2</TD></TR><TR><TD height="20">a</TD><TD>Expenses</TD><TD align="right">4</TD><TD align="right">2</TD></TR><TR><TD height="20">b</TD><TD>Sales</TD><TD align="right">15</TD><TD align="right">2</TD></TR><TR><TD height="20">b</TD><TD>Discounts</TD><TD align="right">5</TD><TD align="right">2</TD></TR><TR><TD height="20">b</TD><TD>Expenses</TD><TD align="right">8</TD><TD align="right">2</TD></TR><TR><TD height="20">c</TD><TD>Expenses</TD><TD align="right">10</TD><TD align="right">2</TD></TR></TBODY></TABLE><P></P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="393"><TBODY><TR><TD height="20" width="64">Company</TD><TD width="201">Metric</TD><TD width="64">Month 1</TD><TD width="64">Month 2</TD></TR><TR><TD height="20">a</TD><TD>= Expenses of <SPAN class="font5">a</SPAN><SPAN class="font0"> / Expenses of </SPAN><SPAN class="font6">c</SPAN></TD><TD>=10/15</TD><TD>=4/10</TD></TR><TR><TD height="20">b</TD><TD>= Expenses of <SPAN class="font5">b</SPAN><SPAN class="font0"> / Expenses of </SPAN><SPAN class="font6">c</SPAN></TD><TD>=9/15</TD><TD>=8/10</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 10 Apr 2018 14:27:18 GMT https://community.qlik.com/t5/QlikView/Proportion-Query/m-p/12903#M2119 narayanamsn 2018-04-10T14:27:18Z Re: Proportion Query https://community.qlik.com/t5/QlikView/Proportion-Query/m-p/12904#M2120 <HTML><HEAD></HEAD><BODY><P>This</P><P></P><P>Dimension</P><P><STRONG>Company</STRONG></P><P><STRONG>Month</STRONG></P><P></P><P>Expression</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum({&lt;Levers = {'Expenses'}&gt;}Value)/Sum(TOTAL <SPAN style="color: #ff0000;">&lt;Month&gt;</SPAN> {&lt;Levers = {'Expenses'}, Company = {'C'}&gt;}Value)</STRONG></P></BODY></HTML> Tue, 10 Apr 2018 14:28:49 GMT https://community.qlik.com/t5/QlikView/Proportion-Query/m-p/12904#M2120 sunny_talwar 2018-04-10T14:28:49Z