topic Re: Count total sales in App Development https://community.qlik.com/t5/App-Development/Count-total-sales/m-p/1250266#M25163 <HTML><HEAD></HEAD><BODY><P>Check the attached app</P></BODY></HTML> Tue, 13 Dec 2016 05:23:10 GMT vinieme12 2016-12-13T05:23:10Z Count total sales https://community.qlik.com/t5/App-Development/Count-total-sales/m-p/1250265#M25162 <HTML><HEAD></HEAD><BODY><P>The customer wants me to count all the sales that has an especific type of item. For example:</P><P></P><P>Table: ITEMS, this are the items that the customer sales.</P><TABLE border="1" class="jiveBorder" height="149" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border: 1px solid #000000; width: 170px; height: 148px;" width="168"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">CodTypeItem</TH></TR><TR><TD style="padding: 2px;">AA100</TD><TD style="padding: 2px;">01</TD></TR><TR><TD style="padding: 2px;">AA900</TD><TD style="padding: 2px;">01</TD></TR><TR><TD style="padding: 2px;">AC600</TD><TD style="padding: 2px;">03</TD></TR><TR><TD>PA333</TD><TD>02</TD></TR><TR><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>TABLA: TypeItem, this are the cateroies of the items</P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid #000000; width: 192px; height: 96px;" width="190"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>CodTypeItem</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>DesTypeItem</STRONG></TH></TR><TR><TD style="padding: 2px;">01</TD><TD style="padding: 2px;"><P>FOOD</P></TD></TR><TR><TD style="padding: 2px;">02</TD><TD style="padding: 2px;">DRINKS</TD></TR><TR><TD style="padding: 2px;">03</TD><TD style="padding: 2px;">OTHER</TD></TR></TBODY></TABLE><P></P><P>TABLA: Sales,</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Clien</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Total</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">Coca</TD><TD style="padding: 2px;">20161210</TD><TD style="padding: 2px;">555</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">Pepsi</TD><TD style="padding: 2px;">20161211</TD><TD style="padding: 2px;">2156</TD></TR><TR><TD>3</TD><TD>Pepsico</TD><TD>20161213</TD><TD>100</TD></TR></TBODY></TABLE><P></P><P>TABLA: SalesDet, sales detail.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000;" width="100%"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ITEM</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">TOTAL</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">AA100</TD><TD style="padding: 2px;">1326</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">PA333</TD><TD style="padding: 2px;">200</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">AA100</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">AC600</TD><TD style="padding: 2px;">667</TD></TR><TR><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>The customers wants a table like this</P><P></P><TABLE border="1" class="jiveBorder" height="99" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid rgb(0, 0, 0); width: 353px; height: 88px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Type</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Numer of sales</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">avg amount per sale</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"></TH></TR><TR><TD style="padding: 2px;">Food</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">500</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">drink</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">123</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">other</TD><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">900</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 13 Dec 2016 01:18:25 GMT https://community.qlik.com/t5/App-Development/Count-total-sales/m-p/1250265#M25162 2016-12-13T01:18:25Z Re: Count total sales https://community.qlik.com/t5/App-Development/Count-total-sales/m-p/1250266#M25163 <HTML><HEAD></HEAD><BODY><P>Check the attached app</P></BODY></HTML> Tue, 13 Dec 2016 05:23:10 GMT https://community.qlik.com/t5/App-Development/Count-total-sales/m-p/1250266#M25163 vinieme12 2016-12-13T05:23:10Z Re: Count total sales https://community.qlik.com/t5/App-Development/Count-total-sales/m-p/1250267#M25164 <HTML><HEAD></HEAD><BODY><P>I already found a way to do it. Thank you very much!</P></BODY></HTML> Tue, 13 Dec 2016 12:44:33 GMT https://community.qlik.com/t5/App-Development/Count-total-sales/m-p/1250267#M25164 2016-12-13T12:44:33Z