topic Re: Need help with Chart in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-Chart/m-p/824347#M1026852 <HTML><HEAD></HEAD><BODY><P>Sorry, the grid looked better before I hit post.</P><P></P><P><IMG src="https://community.qlik.com/" /></P></BODY></HTML> Tue, 03 Mar 2015 23:16:10 GMT scott_simmons 2015-03-03T23:16:10Z Need help with Chart https://community.qlik.com/t5/QlikView/Need-help-with-Chart/m-p/824346#M1026851 <HTML><HEAD></HEAD><BODY><P><EM>We use a configurable product and I would like to do analysis on how often a configuration is used.&nbsp; I am pasting the Grid of Data that came from a quick chart but as you will see the qty and sales are repeated due to the various configuration parameters and I would like to be able to aggregate the metrics(sales, quantity) for how it is configured.&nbsp; Please Help.</EM></P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>%OrderLine</STRONG></SPAN><STRONG> </STRONG><SPAN style="color: #363636;"><STRONG>ConfigLabel</STRONG></SPAN><STRONG> </STRONG><SPAN style="color: #363636;"><STRONG>ConfigValue</STRONG></SPAN><STRONG> </STRONG><SPAN style="color: #363636;"><STRONG>Qty</STRONG></SPAN><STRONG> </STRONG><SPAN style="color: #363636;"><STRONG>Sales</STRONG></SPAN><STRONG> </STRONG><SPAN style="color: #363636;"><STRONG>Avg</STRONG></SPAN><STRONG> </STRONG></TH><TD bgcolor="#f5f5f5"><STRONG>11340 </STRONG><STRONG>$5386.50 </STRONG><STRONG>0.4750 </STRONG></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">703/128963-01/6</SPAN><SPAN style="color: #363636;">11340</SPAN><SPAN style="color: #363636;">$5386.50</SPAN><SPAN style="color: #363636;">0.4750</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">703/128963-01/6</SPAN><SPAN style="color: #363636;"># of Rolls</SPAN><SPAN style="color: #363636;">35</SPAN><SPAN style="color: #363636;">11340</SPAN><SPAN style="color: #363636;">$5386.50</SPAN><SPAN style="color: #363636;">0.4750</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">703/128963-01/6</SPAN><SPAN style="color: #363636;">BAG</SPAN><SPAN style="color: #363636;">11340</SPAN><SPAN style="color: #363636;">$5386.50</SPAN><SPAN style="color: #363636;">0.4750</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">703/128963-01/6</SPAN><SPAN style="color: #363636;">DBL FACED(Y/N)?</SPAN><SPAN style="color: #363636;">N</SPAN><SPAN style="color: #363636;">11340</SPAN><SPAN style="color: #363636;">$5386.50</SPAN><SPAN style="color: #363636;">0.4750</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">703/128963-01/6</SPAN><SPAN style="color: #363636;">FACING</SPAN><SPAN style="color: #363636;">P10</SPAN><SPAN style="color: #363636;">11340</SPAN><SPAN style="color: #363636;">$5386.50</SPAN><SPAN style="color: #363636;">0.4750</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">703/128963-01/6</SPAN><SPAN style="color: #363636;">FACING WIDTH</SPAN><SPAN style="color: #363636;">78</SPAN><SPAN style="color: #363636;">11340</SPAN><SPAN style="color: #363636;">$5386.50</SPAN><SPAN style="color: #363636;">0.4750</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">703/128963-01/6</SPAN><SPAN style="color: #363636;">GLASS WIDTH</SPAN><SPAN style="color: #363636;">6</SPAN><SPAN style="color: #363636;">11340</SPAN><SPAN style="color: #363636;">$5386.50</SPAN><SPAN style="color: #363636;">0.4750</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">703/128963-01/6</SPAN><SPAN style="color: #363636;">Internal Comments</SPAN><SPAN style="color: #363636;">11340</SPAN><SPAN style="color: #363636;">$5386.50</SPAN><SPAN style="color: #363636;">0.4750</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">703/128963-01/6</SPAN><SPAN style="color: #363636;">LENGTH</SPAN><SPAN style="color: #363636;">54</SPAN><SPAN style="color: #363636;">11340</SPAN><SPAN style="color: #363636;">$5386.50</SPAN><SPAN style="color: #363636;">0.4750</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">703/128963-01/6</SPAN><SPAN style="color: #363636;">PLACEMENT</SPAN><SPAN style="color: #363636;">R</SPAN><SPAN style="color: #363636;">11340</SPAN><SPAN style="color: #363636;">$5386.50</SPAN><SPAN style="color: #363636;">0.4750</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">703/128963-01/6</SPAN><SPAN style="color: #363636;">Printable Comments</SPAN><SPAN style="color: #363636;">Bldg. B - Roof - Over Peak</SPAN><SPAN style="color: #363636;">11340</SPAN><SPAN style="color: #363636;">$5386.50</SPAN><SPAN style="color: #363636;">0.4750</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">703/128963-01/6</SPAN><SPAN style="color: #363636;">R-VALUE</SPAN><SPAN style="color: #363636;">19</SPAN><SPAN style="color: #363636;">11340</SPAN><SPAN style="color: #363636;">$5386.50</SPAN><SPAN style="color: #363636;">0.4750</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">703/128963-01/6</SPAN><SPAN style="color: #363636;">TABS</SPAN><SPAN style="color: #363636;">6</SPAN><SPAN style="color: #363636;">11340</SPAN><SPAN style="color: #363636;">$5386.50</SPAN><SPAN style="color: #363636;">0.4750</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">703/128963-01/6</SPAN><SPAN style="color: #363636;">TAPE TAB</SPAN><SPAN style="color: #363636;">N</SPAN><SPAN style="color: #363636;">11340</SPAN><SPAN style="color: #363636;">$5386.50</SPAN><SPAN style="color: #363636;">0.4750</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 03 Mar 2015 23:09:47 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Chart/m-p/824346#M1026851 scott_simmons 2015-03-03T23:09:47Z Re: Need help with Chart https://community.qlik.com/t5/QlikView/Need-help-with-Chart/m-p/824347#M1026852 <HTML><HEAD></HEAD><BODY><P>Sorry, the grid looked better before I hit post.</P><P></P><P><IMG src="https://community.qlik.com/" /></P></BODY></HTML> Tue, 03 Mar 2015 23:16:10 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Chart/m-p/824347#M1026852 scott_simmons 2015-03-03T23:16:10Z