topic Calculating sales contribution in QlikView https://community.qlik.com/t5/QlikView/Calculating-sales-contribution/m-p/294824#M1193478 <HTML><HEAD></HEAD><BODY><P>Perfect! Thank you</P><P></P><P>Graham</P></BODY></HTML> Thu, 16 Jun 2011 15:56:44 GMT 2011-06-16T15:56:44Z Calculating sales contribution https://community.qlik.com/t5/QlikView/Calculating-sales-contribution/m-p/294822#M1193476 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm just starting out with QlikView, but I'm struggling a little to get into the syntax side of things (I'm happy enough pulling the data from Excel and SQL DBs). I have a small set of sales data and I want to calculate a weekly contribution percentage. So, for example in the table below I have the first three columns, but I can't work out how to calculate the fourth:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Product</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Week<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales (£)<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Contribution</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>1</TD><TD>7</TD><TD>29%</TD></TR><TR><TD>2</TD><TD>1</TD><TD>8</TD><TD>33%</TD></TR><TR><TD>3</TD><TD>1</TD><TD>9</TD><TD>38%</TD></TR><TR><TD>1</TD><TD>2</TD><TD>11</TD><TD>44%</TD></TR><TR><TD>2</TD><TD>2</TD><TD>8</TD><TD>32%</TD></TR><TR><TD>3</TD><TD>2</TD><TD>6</TD><TD>24%</TD></TR></TBODY></TABLE><P></P><P>I've used sum(sales)/sum(total sales) to get an overall contribution, but this isn't particularly useful. What am I missing?</P><P></P><P>Thanks!</P><P></P><P>Graham</P></BODY></HTML> Thu, 16 Jun 2011 13:02:52 GMT https://community.qlik.com/t5/QlikView/Calculating-sales-contribution/m-p/294822#M1193476 2011-06-16T13:02:52Z Calculating sales contribution https://community.qlik.com/t5/QlikView/Calculating-sales-contribution/m-p/294823#M1193477 <HTML><HEAD></HEAD><BODY><P>Hi Graham,</P><P></P><P>You almost had it right. You need to use &lt;Week&gt; as qualifier to prevent using all sales, but only the sales of the corresponding week. </P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>sum<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">) / </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> &lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Week</SPAN><SPAN style="font-size: 8pt;">&gt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN></P><P><SPAN style="font-size: 8pt;">HTH Jeroen</SPAN></P></BODY></HTML> Thu, 16 Jun 2011 13:42:09 GMT https://community.qlik.com/t5/QlikView/Calculating-sales-contribution/m-p/294823#M1193477 2011-06-16T13:42:09Z Calculating sales contribution https://community.qlik.com/t5/QlikView/Calculating-sales-contribution/m-p/294824#M1193478 <HTML><HEAD></HEAD><BODY><P>Perfect! Thank you</P><P></P><P>Graham</P></BODY></HTML> Thu, 16 Jun 2011 15:56:44 GMT https://community.qlik.com/t5/QlikView/Calculating-sales-contribution/m-p/294824#M1193478 2011-06-16T15:56:44Z